Inventory Maintenance

Covers BOM Groups, Categories, Dangerous Goods, Docks, Facilities, Facility Groups, Formulators, Item Pictures, Item Planners, Item Search 1-5, Location Types, Locations, Part Exclusions, Reason Codes, Sub-Categories, Units of Measure and Zones

BOM Groups

Bill of Material (BOM) Groups, selectable on BOM Lines within Bills Of Material, allow users to distinguish different BOM lines by group and is used for end user organizational and sorting purposes. Users with access to the "Inventory -- maintenance" setting will have the ability to create or modify BOM Groups.

System Navigation

  • Inventory > Maintenance > BOM Groups

Edit BOM Group form

Opened via the "New" or "Modify" buttons on the BOM Groups form.

Field/Flag

Description

Name

Name of the BOM Group, which must be unique.

Active

If checked, this record is active. Only active records may be used in the system.

Categories

Inventory Categories allow companies to group items that share similar characteristics and are useful for inventory reporting. In addition, inventory Categories are one of the criteria for Deal Pricing, Promotions and Commissions in the Sales Maintenance area of Deacom. Only one category may be assigned to an inventory item. The categories list can contain an infinite number of entries.

System Navigation

  • Inventory > Maintenance > Categories

Edit Category form

Opened via the "New" or "Modify" buttons on the Categories form.

General tab

Button/Field/Flag

Description

Features

If clicked, displays the Features form, which is used to manage sales features applicable to this Category. Features, used in connection with the Deacom Product and Sales Configurator, are a group of similar options that may be chosen or configured based on different sales choices. 

Name

Displays the name of the inventory category, which must be unique.

Sales Quota

Displays the planned annual sales in dollars for this Category. This field is available for use in the Sales > Order Reporting Ranking report.

Active

If checked, this record is active. Only active records may be used in the system.

Default

If checked will provide the default entry when creating new inventory items. 

Restricted Selling

If checked, indicates this is a restricted Category. Restricted selling may be used in a few different ways.

  • Inventory Sub-Categories and Item Search 1-5 fields may also be restricted.

Deacom allows the creation of user-defined fields that, once created are available in various master data records, such as Items, Vendors, Ship-To-Comapnies and many others. These fields allow companies to enter and store information outside of the fields provided in the system. User fields can also be used in connection with User Calculations to and are available for printing on the majority of Part Forms and Report Layouts throughout the system.

Units tab

The Units tab allows companies to define the number of minutes required per unit to receive and ship items in the selected category and is used in conjunction with the Dock calendar to schedule orders.

  • Note: Unit Minutes may also be defined on individual Units of Measure,  Item Masters, and Sub-Categories, allowing companies to define a hierarchy for the minutes that will be required for receiving and shipping.

Button/Field/Flag

Description

Unit Of Measure

Select an appropriate Unit of Measure from the drop down list.

Receiving Minutes

Numeric field used to define the minutes required to receive the Unit of Measure when receiving items in the specified Unit Of Measure that are assigned to this Category.

Shipping Minutes

Numeric field used to define the minutes required to ship the Unit of Measure when shipping items in the specified Unit Of Measure that are assigned to this Category.

Features form

Opened via the "Features" button on the Edit Category form. Displays a list of the Features that have been added to the Category.

Button

Description

Add

If clicked, opens the Edit Feature form and allows the user to select a Feature.

  • The Endpoints or sub-Features within the Feature will be available to all Sub-Categories and items within the Category, unless overridden at those lower levels.
  • Those overrides can remove Endpoints or sub-Features, but not add them, so all available Endpoints and Features should be defined at the Feature level and subtracted from the Feature tree at the appropriate Category, Sub-Category, or Item Master level.

Overrides

If clicked, opens the Feature Overrides form, which displays a feature tree of this Category and all available options and prices, with the capability of overriding pricing and availability.

  • Overrides established at the Category level are in effect at the Sub-Category and Item Master levels, unless overridden at those levels.
  • Once an override is modified and saved, the new value from the Category level will be inherited to the Sub-Category and Item Master levels.

Inclusions

If clicked, opens the Feature Inclusions form, which displays a list of the inclusions and exclusions that have been added to the current Feature.

View Tree

If clicked, displays a feature tree of the selected Feature and all attached options and prices, which can be printed or exported to Excel.

Edit Feature Override form

Opened via the "Modify" button on the Feature Overrides form, which is opened via the "Overrides" button on the Features form.

Field/Flag

Description

Feature

Displays the name of the selected Feature or Endpoint.

Override Price

If checked, allows the user to modify the pre-defined Price of the selected Feature or Endpoint.

Price

Only available when the "Override Price" flag is checked. Allows the user to define a new Price for the selected Feature or Endpoint.

Override Status

If checked, allows the user to modify the availability of the selected Feature or Endpoint.

Status

Only available when the "Override Status" flag is checked. Pick list used to modify the availability of the selected Feature or Endpoint. Options are:

  • Available
  • Default
  • Unavailable

Override Commission

If checked, allows the user to edit the "Commissionable" flag of the selected Feature or Endpoint.

Commissionable

Only available when the "Override Commission" flag is checked. Allows the user to modify the selected Feature or Endpoint to be eligible for Commissions.

Start Date

The date the override begins taking effect.

End Date

The date the override expires.

Containers

In Deacom, Containers represent storage units that hold inventory. Once inventory lots have been moved to Containers, inventory transactions can be performed by referencing the Container instead of the lots inside. This allows inventory to be moved more easily and means fewer transactions. In addition, Containers, like Work Centers, can be depreciated as a fixed asset and have maintenance performed on them via MRO. 

System Navigation

  • Inventory > Maintenance > Containers

Edit Container form

Opened via the "New" or "Modify" buttons on the Containers form.

Field/Button

Description

Post Depreciation to G/L

If clicked, allows users to Post Depreciation for all the selected container in a single click. Details on how the system handles the posting of depreciation to the General Ledger is available in the Fixed Assets tab section below.

General tab

Field/Flag

Description

Number

Enter appropriate number

Part Number

Option to link a part number to the selected container. Only active part numbers with the "Unit Serialization" property checked will be displayed in the list.

  • Used in situations where Containers will be assigned to Bills of Materials which allows visibility and tractability in MRP.

Unit

Select the appropriate Container unit.

Tare Weight

Enter the appropriate tare weight for the selected Container. Tare weight represents the empty weight of the Container.

Active

Check to make the Container active. Only active Containers may be used in the system.

User Fields tab

Deacom allows the creation of user-defined fields that, once created, are available on various master data records such as items, Vendors, and Ship-to Companies. These fields allow companies to enter and store information outside of the fields provided in the system. User fields may be added via Tools > Maintenance > User Fields. 

Fixed Assets tab

Field/Flag

Description

Acquired

Enter the date the Container was acquired.

Acquisition Cost

Enter cost at time of acquisition.

Depreciation

Pick list used to select the method with which depreciation costs are posted. Options are:

  • None - A specific method is not used to reduce the carrying amount of a fixed asset.
  • Straight Line - Generally used to gradually reduce the carrying amount of a fixed asset over its useful life. Designed to reflect the consumption pattern of the underlying asset, and is used when there is no particular pattern to the manner in which the asset is to be used over time. Usually the easiest method to calculate and therefor results in fewer errors.

Account

Account to which depreciation charges will be credited. The corresponding entry is a debit to the "Depreciation Expense" account Accounting > Options.

Months

Indicates the useful life, in months, for this Container.

Current Cost

Displays the current cost for this Container. This field will display the "Acquisition Cost" if "Depreciation" is set to "None". If set to "Straight Line", this field will display as a linear interpolation from the "Acquisition Cost" to zero, based on the "Acquired Date".

Last Posted Cost

Displays the last depreciation cost for the Container that was posted to the GL.

Maintenance tab

The maintenance tab allows for the setup of routine maintenance tasks for the Container and is integrated into MRO Management.

Maintenance form

Opened via the "Add" or "Modify" buttons on the Maintenance tab of the Edit Container form.

Field/Flag

Description

Name

The name for the repair or maintenance task associated to the selected Container.

Recurring Type

Pick list used in connection with the "Frequency" field to specify the unit of when maintenance will be performed on the Container. Options are:

  • Calendar Days - Used in connection with the "Schedule Type", "Day Of", and "Day", the number listed in the "Frequency" field is the number of days on a calendar that will pass until maintenance must be completed.
  • Hours Used - The number listed in the "Frequency" field is the number of hours the Container may be used until maintenance must be completed.
  • Manual - Maintenance is not completed on a set schedule, but as the company/operators see fit. Selecting this option removes the ability to use the "Frequency" field.
  • Metered - Used in connection with the "Meter Reading" flag and "Max Meter Reading" field on this form, the number listed in the "Frequency" field is the meter reading of when maintenance must be performed. A "Metered" task will be due immediately once the meter reading exceeds the Frequency.
  • Quantity Produced - The number listed in the "Frequency" field is the number of units that may be produced on the selected Work Center until maintenance must be completed.

Frequency

Provides the interval indicating how many days, hours, or how much usage is allowed between maintenance task completion.

Schedule Type

Only used with a "Recurring Type" of "Calendar Days". Pick list used to specify the basis of how recurring maintenance tasks, based on the number of Calendar Days specified, will be rescheduled. Options are:

  • Completion Date - Maintenance tasks will be scheduled based on the date a Maintenance Job was completed.
  • Creation Date - Maintenance tasks will be scheduled based on the date a Maintenance Job was created.

For example, assume a maintenance task is set on the Maintenance tab of a Container with a "Recurring Type" of "Calendar Days", a "Frequency" of "7", and the "Schedule Type" is set to "Created Date". Assume a Maintenance Job is created on Monday, Sept 7th. If an MRO report is run, the "Due" column for this Maintenance task will be set to Monday, Sept 14th. Likewise, if the "Schedule Type" was set for "Completion Date" and the same Job was completed on Wednesday, Sept 9th, then running the MRO report would indicate that the "Due" column for this maintenance task would be set to Wednesday, Sept 16th.

Initial Date

Indicates the first date that the system should consider when scheduling maintenance for this Container. When a value is entered and MRO is run, if a Maintenance task has never had a Job finish against it, the system will use this date as the last Job finish date instead of an empty date. When a date is entered in this field, the "Last Date" in MRO gets updated with this same date. If no Jobs have been created for a Maintenance task with a "Recurring Type" of "Calendar Days" previously, then the Initial Date will be set as the "Initial Date" + "Frequency" days.

Day Of

Only used with a "Recurring Type" of "Calendar Days" and used in conjunction with the "Day" field. Pick list used to indicate how the maintenance task due date should be snapped on a calendar when using MRO. Options are:

  • Month - The maintenance task will be snapped to the "Day" indicated for the current month. For example, if "Day" is set to "3" and "Day Of" is set to "Month", the task will snap to the 3rd of the month on the calendar. If the day of the month is less than the current date, it would snap to the following month.
  • None - The maintenance task does not snap based on calendar week or month.
  • Week - The maintenance task will be snapped to the "Day" indicated for the current week. For example, if "Day" is set to "6" and "Day Of" is set to "Week", the task will snap to Saturday on the calendar. If the day of the week is less than the current date, it would snap to the following week.

Day

Only used with a "Recurring Type" of "Calendar Days" and used in conjunction with the "Day Of" field. The value entered in this field indicates the specific day of the month or week (depending on the "Day Of" selection) that the MRO calendar will snap to when scheduling maintenance tasks. The system begins a week with Monday, so with "Day Of" set to "Week", a "Day" set to "1" represents Monday and a "Day" set to "7" represents Sunday.

Part Number

Search field used to select the non-stock item that represents the maintenance or repair activity associated with the selected maintenance task.

MRO Group

Search field used to assign the maintenance task to a group. MRO Groups, managed via Production > Maintenance > MRO Groups allow maintenance tasks assigned to the same group to be placed together on the same Job when creating the Job via MRO.

Unavailability Level

Pick list used to select what impact this maintenance task will have on a machine's or location's availability. Options are:

  • Facility - Used when performing the maintenance task will stop the ability to operate in the Facility to which the Work Center belongs.
  • None - Used when performing the maintenance task permits the ability to operate as normal (no machinery or locations must be shut down or taken offline).
  • Shop Area - Used when performing the maintenance task will stop the ability to operate in the Shop Area to which the Work Center belongs.
  • Work Center - The default value, assuming that the Work Center cannot be used when performing the maintenance task (must be shut down or taken offline).

When Maintenance Jobs are scheduled for maintenance tasks that contain an "Unavailability Level" other than "None", the Master Production Calendar will black out the appropriate Work Centers, Shop Areas, and Facilities to indicate that they will be unavailable while maintenance is performed.

Priority

Used for scheduling purposes and to provide the default value when creating Maintenance Jobs via MRO. Tasks may be set with priorities starting from 1 to an unlimited number, with 1 being the highest priority and 5 being the default. If multiple tasks are set on one Container, the tasks are scheduled according to the value entered in their respective "Priority" fields.

Max Meter Reading

Used in connection with the "Meter Reading" flag. Indicates the point at which the meter will roll over when entering meter readings on Job lines that include a Container with a recurring type of "Metered". This field allows the system to calculate the difference before the meter rolled over to estimate when the next reading should occur.

Copy Document Category

Search field used to copy any documents attached to the Container (via the "View Docs" button on the Edit Work Center form) over to MRO Jobs created for this maintenance task. The documents must belong to the selected Document Category (selected when initially attaching the documents to the Container) to be copied to the Job. The documents can be used as part of the batch ticket record for the Job and may be viewed via the "View Docs" button on the Job.

Notes

Memo field used to store additional details or instructions for IT/Dev/Support MRO tasks.

Meter Reading

Used in connection with the "Max Meter Reading" field. When finishing a Maintenance Job for a task with a "Recurring Type" of "Metered" or this "Meter Reading" flag checked, the "Finish Quantity" field on the Input Production and Close/Relieve Job forms becomes the "Meter Reading" field to enter the current meter value. In addition, The MRO report looks for the last meter reading for each Container compared to the meter reading when the last Metered task was performed to estimate when the next Metered task should be performed. 

Notes:

  1. The Meter Reading from the time the Metered task was performed is displayed in the MRO report.
  2. A reasonable due date is estimated once the Metered task has been completed and another Meter Reading is entered.
  3. A Metered task has no due date if the meter has never been read.
  4. Meter-reading Maintenance Jobs update the Meter ("Meter" variable from the report grid) column of the MRO report for the Metered maintenance task. The maintenance tasks based on the meter will show the Meter Reading at the time they were last performed.
  5. Due dates for Metered tasks are calculated regardless of previous production. The system will also extrapolate dates for Metered task functionality to search up the tree for production in parent Work Centers. This is designed on the idea that Work Centers below top level production Work Centers on the Work Center tree, possibly several levels deep, are for MRO purposes only, and will usually not have Production Jobs assigned to them.

Dangerous Goods Form

The Dangerous Goods maintenance table is used to support the Deacom FedEx integration and the ability to ship goods that are considered dangerous. Once dangerous goods have been identified and added to this table, the Item Master record needs to have the Dangerous Good associated with it indicated on the General tab. Additionally, the Facility(s) from which Dangerous Goods will be shipped need to contain an Emergency Contact Phone Number.

When shipping Sales Orders, the system allows users to select a Dangerous Good on the package lines via the Add Package Line form. The default Dangerous Good is the one specified on the Item Master record, but users may override this default when necessary. Additional information on the Deacom FedEx® integration is available via the Shipping with FedEx and UPS page.

System Navigation

  • Inventory > Maintenance > Dangerous Goods

Edit Dangerous Good form

Opened via the "New" or "Modify" buttons on the Dangerous Goods form.

Field/Flag

Description

Name

Displays the name of the Dangerous Good.

Regulatory ID

Enter appropriate number.

Proper Shipping Name

Memo field. The name required to ship a dangerous good. These names are pre-defined by US DOT and IATA. As a result, there can be different Proper Shipping Names for ground versus Air shipments. Proper Shipping Name must be EXACTLY what FedEx requires including capitalization and punctuation. The current best practice for this field is as follows: In instances where the Proper Shipping Name is different for ground versus air, add multiple Dangerous Good entries one for air, one for ground. On the package line detail, you can choose a different Dangerous Good option.

Technical Name

This field is the technical/chemical name of the specific item being shipped. This name should be on the item master and is the reason for the naming best practice listed above.

Hazard Class

Pick list used to select the Hazard Class to which the good belongs.

  • This selection is required for FedEx Hazardous Material shipping.
  • For more information, refer to the FedEx site's Shipping Hazardous Materials page.

Subsidiary Risk

If a material contains a hazard in addition to the primary hazard, it is specified using this field.

  • Per FedEx regulations, abbreviations and codes are not acceptable.

Packing Group

Choose the correct packing group associated with the dangerous good. Options are I, II, III, and None.

Packing Instructions

Search field used to select the necessary details regarding the packaging of dangerous goods for use with the FedEx integration.

  • Options are maintained via Sales > Maintenance > Packing Instructions.
  • Only FedEx Air shipments, not Ground, require Packing Instructions.
  • The Ship Via form contains a "Packing Instructions Required" flag, which allows companies to control which shipping methods require instructions.
  • When shipping hazardous materials, Packing Instructions are only required if the Ship Via "Packing Instructions Required" flag is set to true AND hazardous materials are in the shipment.
  • The "Dangerous Goods" and "Packing Instructions" fields of the item being shipped are available to the Job Label and Bill of Lading reports.
    • The fields are: dn_name, dn_regnum, dn_shipname, dn_techname, dn_hazard, dn_packgroup, pi_name.

Notes

Long memo field used to store the details regarding the selected dangerous good. This field may be added to print outs associated with the shipment of dangerous goods in Deacom, such as the Bill of Loading.

  • Added in version 17.04.006.

Active

If checked, the record is active. Only active records may be used in the system.

Docks

Docks represent the locations where items will be shipped and/or received. In Deacom, Docks are used in conjunction with the Dock Calendar and are assigned to a specific Facility. Once created, Docks may be selected on either Purchase Orders, Sales Orders, or both, depending on the Transaction Type assigned to the Dock. After a Facility has been selected on the Sales or Purchase Order, only Docks associated to the appropriate Facility are available for selection.

As an example of how Docks work, if a company has a "Dock A" and it is assigned to the "Philadelphia" Facility and has a "Transaction Type" of "Receipts", then the Dock will be available for selection only when adding or modifying a Purchase Order in the Philadelphia Facility, and not when adding or modifying a Sales Order in the Philadelphia Facility.

System Navigation

  • Inventory > Maintenance > Docks

Edit Dock form

Opened via the "New" or "Modify" buttons on the Docks form.

Fierld/Flag

Description

Name

Displays the name of the Dock.

Facility

Search field used to select the Facility to which the Dock belongs.

Facility Group

Search field used to select the Facility Group to which the Dock belongs.

Transaction Type

Pick list used to determine how the Dock will be used in the Facility specified. Options are:

  • All - Indicates Dock will be used to both ship and receive orders.
  • Receipts - Indicates Dock will be used to receive orders.
  • Shipments - Indicates Dock will be used to ship orders.

Active

If checked, the dock is active. Only active docks may be used in the system.

Facilities

Facilities define unique or separate locations that concentrate resources such as workers, machinery, and other capital. Facilities are not limited to production centers and may refer to a distribution or holding location or a specific segment of a company's operations, such as a corporate accounting department, point of sale location, or order fulfillment center.

In Deacom, the Facility master record does much more than store a name and address; the record may contain general ledger posting information specific to the Facility as well as various other inventory and transaction type settings. In addition, the Facility name and address can be printed on reports and documents throughout the system so that print outs may indicate where materials are being stored, shipped from, or produced.

Facilities may be used in a few different ways, including:

  • Transfer Facilities - Used for Inter-Company Transfers, where items are transferred from one Facility to another, within the same company. If a Transfer Facility is specified on a Ship-to Company record, new Sales Orders created for that Ship-to will automatically be defaulted to an Order Type of "Inter-Company Transfer".
  • Hold Facilities - Used in transfer and hold purchasing situations, a Hold Facility may be specified on a Ship-to Location.
  • Invoicing Facilities - Used for Cross-Facility Orders, where items are shipped from one Facility but invoiced out of another. If an Invoice Facility is specified on a Ship-to Company record, new Sales Orders created for that Ship-to will automatically be defaulted to an Order Type of "Cross-Facility".
  • When running a facility-filtered version of MRP, and there is a suggestion for an item that is not marked as manufacturable in that facility, Deacom will not go through the contents of the BOM of this item and won't show demand for the BOM ingredients of that item as it cannot be manufactured in that particular facility.

System Navigation

  • Inventory > Maintenance > Facilities

Edit Facility form

Opened via the "New" or "Modify" buttons on the Facilities form.

General tab

Field/Flag

Description

Name

Displays the name of the Facility, which must be unique.

Street

First line of the Facility address.

Street 2

Optional second line of the Facility address.

City, State, Zipcode, Country

City, State, Zipcode, and Country of the Facility.

Phone

Primary phone number for the Facility.

  • When using the FedEx option in Deacom, this field together with the Street, City, State, Zipcode, and Country Code are required.

Country Code

Search field used to select a Country Code phone mask for the Facility, if required. 

Global Location Number

Displays the GLN for the Facility, if required.

  • 13 digit part of the GS1 systems of standards
  • Is a simple tool used to identify a location and can identify locations uniquely where required.

Currency

Search field used to select a Currency other than the default that will be used to book transactions that occur for this Facility.

  • Useful for scenarios in which Facilities may be located in different countries and therefore their home Currencies would differ and the Facility transactions should be booked in a foreign currency, including values for inventory, labor, burden, etc.
  • In association with this option the following fields/features have been added in the system:
    • A read only "Currency" field on the Edit Facility Item > Costs tab for reference.
    • Currency conversion has been added to BOM roll-ups and all inventory transactions that use standard cost or transfer between Facilities.
    • Display warnings to alert users when posting to an account with a Currency different than the transaction Currency.
    • A "Currency" filter has been added to multiple reports in Inventory Reporting and Job Reporting and the reports have been enhanced to calculate in the specified Currency.

Fax

Displays the Facility facsimile machine number, if known.

Emergency Contact

Character text field. Displays the name of the individual to contact in case of an emergency.

Negative Inventory

Pick list used to select the conditions in which items purchased, produced, or sold in this Facility are allowed to go negative. This selection overrides the default selection on the Item Master General 1 tab. Options are:

  • Always - Inventory is always allowed to go negative in this Facility, regardless of the setting on a Part's Item Master. If "Always" is selected, the inventory availability color on the Master Production Calendar will display as green, even when there is not enough inventory on hand.
  • Follow Part - The "Negative Inventory" selection on the Item Master General 1 tab dictates how negative inventory is handled in this Facility.
  • Never - Inventory is never allowed to go negative in this Facility, regardless of the setting on a Part's Item Master.
  • Once - Items in this Facility are allowed to go negative once, but cannot go further negative until the situation is resolved and inventory changes to positive.

Print Substitutions

Search field used to select a Print Substitution Group for forms printed when this Facility is used. 

Active

If checked, this record is active. Only active records may be used in the system.

Default

If checked, the selected Facility will be defaulted whenever a transaction or record contains a "Facility" field.

Prevent Inventory Transactions

If checked, inventory transactions other than physical inventory postings (such as issues, reserves, and moves) will be prevented from occurring for this Facility.

  • This flag should be checked when performing physical inventories to ensure that no transactions occur between the time the inventory snapshot is taken and the time when the physical inventory worksheet is posted.
  • If checked and a user attempts to perform an inventory transaction for this Facility, a system prompt will be displayed to prevent the transaction from occurring.
  • This flag also exists on Item Master, Item Master Facility, Location Type, and Location records.
  • Note: If the "Automatically Prevent Included Item Transactions" field on the Physical Inventory Forms form is checked, this prevents users from performing inventory transactions on all items, or facility-specific items, if a Facility is indicated on the form when performing a physical inventory or cycle count. The field allows companies to more quickly prevent inventory transactions then using the alternative option of checking the "Prevent Inventory Transaction" flag on the item master record, either individually, or via the Price Updates Excel feature.

Transfer Hold Lot Control

If checked, the system will enforce lot control when performing the second receipt of a Transfer Hold Purchase Order process. This means that users will only be able to select and receive lots that were received into the Hold Facility during the first receipt in the process.

  • If using Purchase Order QC Testing with Transfer Hold Purchase Orders, this flag must be checked to ensure the QC Tests assigned to lots are maintained when lots are transferred to different Facilities.
  • If this flag is checked, catch weight values may be entered when initially receiving lots on a Transfer and Hold Purchase Order where this Facility is specified as the transfer facility.

APIs tab

Note: Beginning in version 17.03, the API tab is no longer available via Inventory > Maintenance > Facilities. The API Profiles form, available beginning in version 17.03, consolidates all of the API fields and function for FedEx, UPS, EasyPost, and sales tax options previously available on this tab. The form also supports the additional API profiles including QuickBooks Online and the USPS.

Sales tab

Field/Flag

Description

IC Xfer Markup Type

Pick list used to select how inventory lots will be costed when received via Inter-Company Transfers into this Facility or when invoicing from this Facility when using Cross-Facility Orders.

For Inter-Company Transfers, the current lot cost of material being transferred is not automatically used to determine the cost of material that is received into the receiving Facility. For example, assume an item has a list price of $5.00 specified on the Item Master Costs 2 tab, but that there is inventory of this item in "Plant A" with a lot cost of $7.00. If the Facility tab of "Plant B" has a Markup Type of "List Plus $" and nothing is specified in the "Markup Factor" field, the lot of the transferred item will be costed at $5.00 and not $7.00 when lots of this item are transferred and received into "Plant B" via the use of an Inter-Company Transfer. Also, when receiving an Inter-Company Transfer using any Markup Type other than "Ship and Hold", the Invoice Date on the order will populate with the Receipt Date.

For Cross-Facility Orders, the Markup Type needs to be set on the invoicing Facility, and lots are costed when the Cross-Facility Order is shipped.

Options are:

  • Cost Plus % - The lot cost plus the value specified in the "Markup Factor" field below.
  • Current Price Minus % - The "Current Total" as listed on the part's Item Master Costs tab less the value specified in the "Markup Factor" field below.
  • Current Price Plus $ - The "Current Total" as listed on the part's Item Master Costs tab plus the value specified in the "Markup Factor" field below.
  • Dollars Per Unit - The value specified in the "Markup Factor" field below will be used for each part unit transferred.
  • List Minus %
    • For Cross Facility Orders - The price as defined on the order less the value specified in the "Markup Factor" field below.
    • For Inter Company Transfers - The price as defined on the Item Master Field "List Sales Price" field less the value specified in the "Markup Factor" field below.
  • List Plus $
    • For Cross Facility Orders - The price as defined on the order plus the value specified in the "Markup Factor" field below.
    • For Inter Company Transfers - The price as defined on the Item Master Field "List Sales Price" field plus the value specified in the "Markup Factor" field below.
  • Ship and Hold - The lot cost of shipped inventory will be written off to the Cost of Goods sold account associated with the item master(s) Revenue account at the time of shipment.
  • Transfer Cost - The "Transfer Cost" as defined in the "Transfer Cost Expression" field on the Sales 2 tab within in System > Options; or if that field is empty, the value in the "Transfer Cost" field on the part's Item Master Costs 2 tab. The "Transfer Cost Expression" on this form will take priority over the other two previously mentioned fields.

Markup Factor

Defines the percentage or dollar amount that will be applied when receiving material on Inter-Company Transfers or shipping material via Cross-Facility Orders and using an "IC Xfer Markup Type" other than "Item Master Transfer Cost" or "Ship and Hold".

  • A markup factor may be defined on both a Facility and a part's Item Master General 2 tab via the "IC Trans Markup %" field. If factors are set in both fields, both values will be added to the order price.
  • A "Markup Factor" of 0% will transfer the material at cost.

Incremental Reserve

Pick list used to allow or restrict reserving incremental inventory within this Facility while using WMS. Incremental reserving was added for customers that need the ability to track and report lots as they are issued incrementally in Deacom and not just the total "rolled up" amounts or issued materials/lots. For example, if a Sales Order requires 170 pounds of sugar, and sugar is handled in 50 pound bags, a user would stage three bags and 20 pounds of loose sugar in a container. For some customers, seeing the sugar listed as 170 pounds on the Sales Order is acceptable; other customers may have process controls that demand they track the exact containers and increments and thus would want 4 lines of sugar on the order for 50, 50, 50, and 20 pounds, respectively. Options are:

  • Both - Inventory may be both incrementally reserved and staged.
  • None - Inventory may not be incrementally reserved or staged.
  • Reserve - Inventory may be incrementally reserved, but not staged.
  • Staging - Inventory may be incrementally staged, but not reserved.

ICT Receipt Qty

Pick list used to determine how multiple Lots of the same Part are handled when receiving material on an Inter-Company Transfer. Options are:

  • Lot - Forces the user to receive each Lot of a Part individually. Example: If an Inter-Company Transfer is created for 1,000 units of Part A and 10 Lots of 100 are shipped, when receiving, the user must enter that they counted 100 of Lot 1, 100 of Lot 2, 100 of Lot 3, etc.
  • Part - Defaults the amount to receive to the full amount of all Lots for the selected Part on the order. Example: If an Inter-Company Transfer is created for 1,000 units of Part A and 10 Lots of 100 are shipped, when receiving, the user may receive all 10 Lots totaling 1,000 units in one transaction.

Automatically Receive ICT

If checked, Inter-Company Transfers sent to this Facility will be received automatically.

  • Supports situations in which material needs to be put away in defined Locations when receiving. The logic checks the following:
    • The "Default Location" selected on the Facility assigned to the part's Item Master.
    • The "Default Location" on the part's Item Master General 1 tab.
    • The Location flagged as default for the Location Type flagged as default for the Facility selected on the order.
  • A prompt will be displayed if this flag is checked but there is incorrect setup.

Allow Inter-Co. Transfer To Facility

If checked, this Facility may receive material shipped on Inter-Company Transfers.

Retain Inter-Co. Transfer Location

If checked for the receiving Facility on an Inter-Company Transfer, the system will keep the material in the same Location and Location Type as it originated from the shipping Facility. If the same Location and Location Type do not exist for the receiving Facility, the receiving Facility defaults will kick in.

  • Useful in situations where customers need to support the "receipt" of items into a "customer owned" Facility, where materials will not physically move form their storage Location.

Custom Part First When Reserving ICT in WMS (requires WMS license)

If checked, ensures the lot picker for a custom part automatically opens when reserving an ICT in Reserve SO in the Warehouse Management System. If the option is un-checked and an inter-company transfer has one or more stocked parts, the form defaults to the first part in the part list and a lot picker does not automatically open (similar behavior to reserving to a normal sales order). 

Finish Linked Job Upon Shipment

If checked, the quantities shipped from this Facility on Inter-Company Transfers, regular Sales Orders, and Cross-Facility Orders are automatically finished on the linked header or line Job.

  • Useful in situations where a co-packer makes finished goods for customers. For example, the customer may ship components and raw materials to a co-packer several times per week, via Inter-Company Transfers. Once the co-packer assembles and ships the finished goods (via ICT) back to the original Facility, the system will automatically consume/backflush the components and raw materials on the corresponding Job, assuming the shipping Facility on the second ICT has this flag marked as true and a header or line Job linked.
  • Requires the "Allow Inter-Co. Transfer To Facility" flag to be set to true.
  • A Facility, Location Type, and Location representing the co-packer must exist.
  • When shipping lot required items on ICTs and the Facility has this flag set to true, the system will generate a user lot for the material. Specifically, the system will gather linked Job lines and generate user lots for the lines then set the user lot variable on the order line to the value of the Job line's user lot with the same part id.

Ship on Save (requires WMS license)

Sets the default value for the "Ship on Save" flag on the Reserve SO form in WMS.

  • Allows users to ship the order once all inventory has been reserved and all information has been correctly entered.
  • Only displayed when the Reserve SO form is accessed from the Ship Sales Order form in WMS.

Don't Require Lot Tracking on DSD

If checked, the system will not require that a specific lot be selected when shipping Sales Orders from this Facility using the Direct Store Delivery application. Instead, the system will use FIFO rules to select the lots for lot tracked items.

POS Default Bill-to (requires POS license)

Search field used to select a Bill-to Company, assuming this Facility represents a location where the Point of Sale application is used. When entering an order via POS, if the Bill-to selected is also specified in this field of a Facility, that Facility will automatically populate on the order. 

CC Processor

Search box for all active Credit Card Processors, to select which Processor should be used for this facility when calculating sales tax information. In terms of credit card processor hierarchy, this field overrides the System Default, but not the the Bill-To Company Override. The hierarchy is:

  • System Default CC Processor (enabled via the "Default" flag on the Edit Credit Card Processor form.)
  • Facility CC processor (this field)
  • Bill-To Company CC processor, located in Sales > Customers > Modify Bill-To Company

This field was added to support companies that have different Merchant IDs in different Facilities.

Default Shipping Qty

Pick list that determines the default shipping quantity at the facility level, which takes priority over the System options but still below Item level. Options include:

  • Follow Sales Options - Default. Will use the option set in Sales Options.
  • As Reserved - Sets the "Ship" quantity to the quantity reserved to the Sales Order (which may be less than the quantity ordered) and backorders the remaining quantity.
  • Full - System will apply either the full requirements or all of the item available based off of the set Location and Lot filters.
  • Zero - Sets the default quantity to 0. Must be selected if shipping with FedEx. This is because users will in essence build the Package(s) while preparing the items for shipment and will need to determine, possibly by weighing, the quantity that will be placed in the Package(s) for shipment, according to the established FedEx parameters.

Example: An order for 2 or 3 boxes of chocolates which will require the users to begin with zero quantity then make and weigh the three packages prior to generating labels and completing the shipping process. Additional information on the FedEx process is available via Shipping with FedEx and UPS.

Note: The General 2 tab on the item master record also contains a Default Shipping Qty field. If the field in the item master is set to "Default," the system will use the Default Shipping Qty option set here in System Options. If the item master has a different setting than "Default," the system will use the specified option only when shipping sales orders containing that item.

Retain Lot Costs on IC Xfer

If checked, the lot will be received into the facility at the current cost, with no markup added to the inventory value.

  • The inventory value plus any markup will be posted to the revenue accounts on the order lines. This value will be posted to the markup account as a debit in order to balance the transactions.

Override Tax Jar Address with Facility

If checked,  will switch the facility and ship to locations when using TaxJar AND the state on the facility/ship to are the same.

Prompt When Over Reserving

If checked, users will always be prompted with a yes/no prompt to confirm that they are over reserving/staging material on Sales Orders in this Facility.

  • Checked by default.
  • This flag applies to both the main application and WMS.
  • Un-checking this flag is useful in situations where customers will always over reserve, such as when reserving full pallet quantities.

Production tab

Field/Flag

Decription

Production Relief

Pick list used to determine how lots issued to WIP Jobs, or moved to Shop Areas, will be relieved during production. Options are First Expired and First Issued.

  • Useful in situations where the relief of materials during production needs to be in sequence with the actual physical consumption/use of materials. In other words, in situations where companies will use the materials based on the sequence of how they were physically delivered to the Job, whether issued or not.
  • When set to "First Expired" and all other lot criteria are tied, the system will check the system lot before the user lot to determine the tie breaker.
  • When Production Relief is set to First Issued, this is the hierarchy for lot relief.
    1. fi_type ("special" has highest priority, then "sale" and "job", then "sal-reserv", then everything else)
    2. If the part currently being relieved has “restrict job relief to shop area locations” set to TRUE, AND if any fi_loid are in shop locations, it gets higher priority
    3. fi_date
    4. fi_recdate
    5. fi_attrib1
    6. fi_attrib2
    7. fi_attrib3
    8. fi_expires
    9. fi_lotdate
  • When Production Relief is set to First Expired, this is the hierarchy for lot relief.
    1. fi_type ("special" has highest priority, then "sale" and "job", then "sal-reserv", then everything else)
    2. if any fi_loid are in shop locations, it gets higher priority
    3. whether fi_expires is null or not (if fi_expires is not null, that lot has higher priority)
    4. fi_type (any type that is NOT "staging", "Reserved inventory", or "sal-reserv" gets higher priority)
    5. fi_expires
    6. fi_lotdate
    7. fi_attrib1
    8. fi_attrib2
    9. fi_attrib3
    10. fi_balance
    11. fi_lotnum
    12. fi_id

Incremental Issue

Pick list used to allow or restrict issuing incremental inventory within this Facility while using WMS. Incremental issuing was added for customers that need the ability to track and report lots as they are issued incrementally in Deacom and not just the total "rolled up" amounts or issued materials/lots. For example, if a Job requires 170 pounds of sugar, and sugar is handled in 50 pound bags, a user would stage three bags and 20 pounds of loose sugar in a container. For some customers, seeing the sugar listed as 170 pounds on the Job is acceptable; other customers may have process controls that demand they track the exact containers and increments and thus would want 4 lines of sugar on the Job for 50, 50, 50, and 20 pounds, respectively. Options are:

  • Both - Inventory may be both incrementally issued and staged.
  • Issue - Inventory may be incrementally issued, but not staged.
  • None - Inventory may not be incrementally issued or staged.
  • Staging - Inventory may be incrementally staged, but not issued.

Default Issue Quantity

Pick list used to determine how the system will populate the default issue quantity for this Facility, on issuing forms in the main application and WMS and in the "Quantity" field on the Inventory Final Staging form. Options are:

  • Follow System Options (default setting) - the system will use the selection in the "Default Issue Quantity" field in Production > Options for jobs in this Facility.
  • Full - the full remaining amount required by the job.
  • Zero - issue quantity will default to zero.

Notes: If set to "Full", the system will apply either the full requirements or all of the item available based off the set Location/Lot filters. 

Prompt When Over Issuing

If checked, users will always be prompted with a yes/no prompt to confirm that they are over issuing/staging material on Jobs in this Facility.

  • Checked by default.
  • This flag applies to both the main application and WMS.
  • Un-checking this flag is useful in situations where customers will always over issue, such as when issuing full pallet quantities.

Restrict Operations to Routings in Log On/Off Jobs

If checked, users will only be able to select Operations specified on the Job's Routing when Logging On/Off Jobs in the WMS application and in the main application via the Production > Payroll Entry transaction.

Prompt When Under Issuing

If checked, users will always be prompted with a yes/no prompt to confirm that they are under issuing/staging material on Jobs in this Facility.

  • This flag applies to both the main application and WMS.

Group By Part Number When Issuing

If checked, BOM lines will be grouped by Part Number on the Issue/Reserve Inventory form when issuing to a Job in the selected Facility.

  • If not checked, BOM lines will not be grouped; Instead they will be listed individually by BOM Sequence number even if multiple sequences contain the same Part.

Facility Groups tab

Facility Groups are mainly used for reporting purposes and to restrict a user's access to only orders and transactions for Facilities contained in the Facility Group. Facilities may be assigned to multiple Facility Groups and Users may be restricted to a specific group by following the steps outlined in Managing Users and User Security

GL Overrides tab

GL overrides by Facility is the behavior where inventory transactions can override the GL code affected, based on the Facility in which the transaction is being performed. This allows some or all Facilities to use different GL codes, if desired. GL Overrides are populated from the Chart of Accounts form, accessible via Accounting > Maintenance > Chart of Accounts.

Restricted Selling tab

Items with Inventory Categories, Sub-Categories, and/or Item Search 1-5 fields marked true for "Restricted" are not available for sale unless specifically designated. The Restricted Selling tab on the Edit Facility form allows items with restrictions or restricted Categories/Sub-Categories/Item Search 1-5 to be assigned, therefore making them available for sale from the selected Facility. 

Tax Regions tab

The Tax Regions tab is used to establish regions that will be used whenever this Facility is selected during Sales Order entry. Ship-to records and Zipcodes may also contain Tax Regions, but these choices will be overridden by the Facility setting. There is no limit to the number of Tax Regions that can be set. More information on this feature is available via Managing Customers Using Tax Regions. Additionally, Deacom now offers the ability to use a TaxJar or AvaTax integration. These services allow companies to automate sales tax calculations and auto file state taxes. 

Deacom allows the creation of user-defined fields that, once created are available in various master data records, such as Items, Vendors, Ship-To-Comapnies and many others. These fields allow companies to enter and store information outside of the fields provided in the system. User fields can also be used in connection with User Calculations to and are available for printing on the majority of Part Forms and Report Layouts throughout the system.

Print Destinations tab

Print Destinations allow companies to set the printers to which Part Forms and Report Layouts will print without requiring the user to select from a list. Print Destinations are also useful in situations where companies will have multiple printers associated to a production "line" or specific packaging area. For example, a company may have 2 printers in the line 1 and line 2 packaging rooms printing the same labels. 1 printer is a label printer printing a 4x6 case labels and 1 printer will be a sheet printer printing an 8x11 skid sheet. Once Print Destinations have been created, they may be assigned to the appropriate Facilities using this tab. 

Facility Groups

Facility Groups are mainly used for reporting purposes and to restrict a user's access to only orders and transactions for Facilities contained in the Facility Group. 

System Navigation

  • Inventory > Maintenance > Facility Groups

Edit Facility Group form

Opened via the "New" or "Modify" buttons on the Facility Groups form.

Field/Flag

Description

Name

Displays the name of the group.

Active

If checked, this record is active. Only active records may be used in the system.

Default

If checked, this Facility Group is the default selection when assigning a group to a Facility.

Features

A Feature is a group of similar, usually mutually exclusive, Endpoints (or Options). For example, a house might have a single space for a refrigerator, and the buyer could choose to have a 16 cubic foot, 18 cubic foot, or 20 cubic foot refrigerator in the space. The refrigerator is considered a Feature, while the three choices of 16, 18, and 20 are considered Endpoints or Options. Features can also be members of higher level Features, so that an upper level Feature of Kitchen can have sub-features of Refrigerator, Range, and Garbage Disposal, with each of those having a list of available Endpoints. The configuration choices are presented on the Sales Order as a Feature Tree, showing top level Features, their component Features (possibly multiple levels), and finally the Endpoints.

Features are used in connection with the Deacom Sales Configurator, which is an agreement between sales, production, and engineering/design as to which options are available on each model, which options do not work with other options, which options or packages include other options, and the costs of options on various models. In Deacom, Sales Configurator definition begins with the creation and linking of Features and Endpoints, and then is further defined at the Category, Sub-Category, and Item Master levels. The desired end result is that the correct options are available for each configured item, with proper sales pricing. Detailed information on the use of the Sales Configurator is available via Building Sales Orders with the Product Configurator.

Additionally, Features may have inclusions and exclusions defined. Inclusions are cases where the selection of an Endpoint in one Feature automatically selects another Endpoint in another Feature.

  • One example is a package, like a Deluxe Kitchen, that includes a list of lower level Endpoints, usually at no charge beyond the option price of the package.
  • Another example is an individual endpoint, such as 15” tires, which need to include 15” wheels to work properly. Inclusions do not necessarily exclude other choices, they just change the default. If the choice of 15” tires includes the standard set of 15” steel wheels, another choice of 15” aluminum alloy wheels might also be possible.

If certain choices for an Endpoint such as 15" tires should not be possible, like 14” or 16” wheels, then Exclusion rules need to be used to prevent their selection. Exclusions are cases where the selection of an Endpoint in one Feature is incompatible with another Endpoint in another Feature, and should prevent its selection.

  • The incompatibility can be functional, as in 15” tires that exclude the selection of 16” wheels, or relatively arbitrary, as in a deep pile carpet that excludes the selection of thin padding.
  • Exclusion rules in Deacom are one way, meaning that a rule that says A excludes B does not inherently mean B excludes A. If B should exclude A, then a second Exclusion rule should be added

System Navigation

  • Inventory > Maintenance > Features

Features form

The Features form contains two pick lists, "Active" and "View", used to determine what records are displayed in the form. The "Active" pick list provides the options of Active, All, or Inactive and the "View" pick list provides the options of All, Endpoints, and Features. This form also contains three buttons, "Add Feature", "Add Endpoint", and "Modify", used to open the Edit Feature and Edit Endpoint forms.

Edit Endpoint form

Opened via the "Add Endpoint" or "Modify" buttons on the Features form.

Field/Flag

Description

Name

Displays the name of the Endpoint, which must be unique.

  • Endpoints are displayed below the Feature to which they are attached, so it is not necessary to repeat the name of the Feature in the name of the Endpoint.

Quantity

Used to store the default quantity of the selected Endpoint, which is usually 1, that will be added to the configuration when this Endpoint is selected.

Price

Used to store the default sales price of the selected Endpoint.

Part Suffix

Field used to dictate the suffix, up to 10 characters, that the Sales Configurator should use to build and link to part numbers.

  • When selecting Endpoints with suffixes in the Sales Configurator, the "Part Structure" field displays the original part number with the selected suffixes appended. When the user saves the configuration, the system looks for a part number that matches the part structure and if it finds one, prompts the user to use that item instead of the Feature item.

Notes

Memo field used to store notes about the selected Endpoint, which will be copied into the resulting configuration on the Sales Order, if this Endpoint is selected.

Active

If checked, this record is active. Only active records may be used in the system.

End Point

If checked, this record is considered an Endpoint, as opposed to a Feature.

Commissionable

If checked, the sales price of this Endpoint is subject to Commission calculation rules.

Apply Deal Pricing

If checked, the sales price of this Endpoint is subject to modification by Deal Pricing rules.

  • Cost Plus Margin Deal Types are not applicable to Endpoints since there are no costs directly associated with them.

Apply Promotion Codes

If checked, the sales price of this Endpoint is available as a basis for Promotions calculations.

Edit Feature form

Opened via the "Add Feature" or "Modify" buttons on the Features form.

Field/Flag

Description

Add

If clicked, opens the Edit Option form, used to attach a specific Part Number directly to a Feature, and optionally mark it as default, when the use of multiple Endpoints is not necessary. Otherwise, Endpoints can be linked to Item Masters in a way that the selection of several Endpoints brings a single Item Master, and its Bill of Materials, into the configuration.

Add Options

If clicked, opens a mover form used to add a collection of Features or Endpoints to the current Feature.

  • The mover form will display all active Features and Endpoints except the current Feature and all previously included Features and Endpoints.
  • Once all desired records have been moved to the right-hand side of the form, clicking "Continue" will close the mover form and add the selections to the current Feature.
  • Options added in error may be removed using the "Delete" button on the Edit Feature form.

View Tree

If clicked, displays a feature tree of the selected Feature and all attached options and prices, which can be printed or exported to Excel.

Inclusions

If clicked, opens the Feature Inclusions form, which displays a list of the inclusions and exclusions that have been added to the current Feature. More information is available in the Edit Inclusion/Exclusion form section below.

Name

Displays the name of the Feature, which must be unique.

Quantity

Used to store the default quantity of the selected Feature, which is usually 1, that will be added to the configuration when an Endpoint of this Feature is selected.

Active

If checked, this record is active. Only active records may be used in the system.

End Point

If checked, this record is considered an Endpoint, as opposed to a Feature.

Multiple Selection

If checked, this Feature allows the selection of multiple Endpoints.

  • Not normally checked as Endpoints within a Feature are typically mutually exclusive.
  • Desirable in a list of miscellaneous or unrelated packages or options.

Commissionable

If checked, the sales prices of the Endpoints of this Feature are subject to Commission calculation rules.

Apply Deal Pricing

If checked, the sales prices of the Endpoints of this Feature are subject to modification by Deal Pricing rules.

  • Cost Plus Margin Deal Types are not applicable to Endpoints since there are no costs directly associated with them.

Apply Promotion Codes

If checked, the sales price of this Endpoint is available as a basis for Promotions calculations.

Required

If checked, the selection of an Endpoint is required when selecting this Feature.

  • If a user attempts to exit the Sales Configurator without selecting an Endpoint for a Feature with this flag checked, they will receive a prompt and be required to select an Endpoint prior to saving and exiting.

Edit Inclusion/Exclusion form

Opened via the "Add" or "Modify" buttons on the Feature Inclusions form, which is opened via the "Inclusions" button on the Edit Feature form.

Field/Flag

Description

Parent Feature

Pick list used to select the Parent-level Feature. Options include the sub-Features that are a part of the current Feature (all records with a value of "No" in the "EndPoint" column of the Edit Feature form).

Parent Value

Pick list used to select the Parent-level Endpoint. Options include the Endpoints that are a part of the sub-Feature selected in the "Parent Feature" pick list.

Child Feature

Pick list used to select the Child-level Feature. Options include the sub-Features that are a part of the current Feature (all records with a value of "No" in the "EndPoint" column of the Edit Feature form).

Child Value

Pick list used to select the Child-level Endpoint. Options include the Endpoints that are a part of the sub-Feature selected in the "Child Feature" pick list.

Exclusion

If checked, this record is handled as an Exclusion.

  • When a user is building a Sales Order and selects the Endpoint defined in the "Parent Value" field, the Endpoint defined in the "Child Value" field will be prevented from also being selected on the same order.

If not checked, this record is handled as an Inclusion.

  • When a user is building a Sales Order and selects the Endpoint defined in the "Parent Value" field, the Endpoint defined in the "Child Value" field will automatically be added to the same order.

Include At No Cost

If checked, when a user is building a Sales Order and selects the Endpoint defined in the "Parent Value" field, the Endpoint defined in the "Child Value" field will be added to the same order at no additional cost.

Formulators

Formulators are used to indicate the name of individuals or departments responsible for conceiving and maintaining item formulas and bills of materials revisions in Inventory > Bills Of Material. Formulators can be restricted to only have access to view and modify revisions assigned to them. Users with access to the "Inventory -- maintenance" setting will have the ability to create or modify formulators.

System Navigation

  • Inventory > Maintenance > Formulators

Edit Formulator form

Field/Flag

Description

Name

The Name of the Formulator or responsible department, which must be unique.

Active

If checked, this record is active. Only active records may be used in the system.

Default

If checked, this will be the default Formulator on forms throughout the system that contain a "Formulator" field. Users may override the default if necessary.

Item Pictures

Item Pictures allow the identification of Parts by graphical pictures when using the Point of Sale application and when listed as Saleable Parts on configured eCommerce Sites. First, graphic files representing individual items are uploaded to the Item Pictures maintenance table. Then, individual Parts are modified and the appropriate image file is selected in the "Item Picture" field on the Item Master General 2 tab. Once POS Buttons are created and assigned to a Category, they will display in the POS application. In POS, clicking this Category's button will display icons for all items in that Category. Those items that have an Item Picture assigned will display the graphic image as well as the Part's name and description, otherwise only the Part information will be listed and the rest of the icon will appear blank. If no POS Buttons are configured, when selecting an item via the "Add Part" button, all Parts will be displayed in a list format rather than using icons.

This feature is only available in web versions of Deacom.

System Navigation

Inventory > Maintenance > Item Pictures

Edit Documents form

Button/Field

Description

Add

If clicked, opens the Edit Document Entry form, used to add a new picture record.

Modify

If clicked, opens the Edit Document Entry form, used to modify the selected record.

Delete

If clicked, deletes the selected record.

View

If clicked, opens the picture selected.

Send Email

If clicked, opens a mover form used to select one or more records to attach to an email.

Edit Document Entry form

Opened via the "Add" or "Modify" buttons on the Documents form.

Field

Description

Name

Search field that opens a file explorer used to select the item picture. Displays the actual name of the image.

Description

Displays a description of the image.

Document Category

Search field used to select the appropriate Document Category for the item picture.

Print Destination

Option to specify a printer where the attached file will be printed instead of the printer defined in the "Print Destination" field on the Report Layout or Part Form.

  • All active printers defined in the Print Destinations will be available for selection in this field. Option to specify a printer where the attached file will be printed instead of the printer defined in the "Print Destination" field on the Report Layout or Part Form. All active printers defined in the Print Destinations will be available for selection in this field.

Item Planners

Item Planners are created then assigned to the appropriate Parts on the Item Master General 1 tab. The "Item Planner" is a pre-filter in many Inventory reports, so that a Planner can see only the items that he or she is responsible for, within or across Categories. Only one planner may be assigned to an item. In addition, users may be restricted by Item Planner so that they will only be able to see items that contain the Item Planner to which they are assigned. The Item Planners list can contain an infinite number of entries. Users with access to the Inventory Maintenance menu will have access to add and modify Item Planners.

System Navigation

  • Inventory > Maintenance > Item Planners

Edit Item Planner form

Opened via the "New" or "Modify" buttons on the Item Planners form.

Field/Flag

Description

Name

Displays the name of the Item Planner, which must be unique.

Active

If checked, this record is active. Only active records may be used in the system.

Default

If checked, the selected Item Planner will be the default when adding new items via Item Master.

Item Search 1-5

Deacom offers five user-defined Item Search fields that can be used to define additional criteria for Item Master records. Captions for these fields are defined in System > Maintenance > Captions and field selections are made on the Item Master User Fields tab for each Part. These Item Search fields are available on the Inventory Reporting pre-filter to assist with searching and analyzing items and for printing on inventory forms such as Item Master labels, Formulas, and Batch tickets. In addition, these fields are one of the criteria for Deal Pricing, Promotions, and Commissions. These fields are required and must have at least one default entry each. Companies not wishing to use these fields on Item Master records may enter a default value of "None". Users with access to the Inventory Maintenance menu will have access to add and modify selections.

System Navigation

  • Inventory > Maintenance > Item Search 1-5

Edit Item Master User form

Opened via the "New" or "Modify" buttons on the Item Search 1-5 forms.

General tab

Field/Flag

Description

Name

Displays the name of the option, which must be unique.

Active

If checked, this record is active. Only active records may be used in the system.

Default

If checked, the selected option is the default for the "Item Search 1-5" fields on the User Fields tab when adding new Parts via Item Master.

Restricted Selling

If checked, indicates this is a restricted Item Search field. Restricted selling may be used in a few different ways.

Deacom allows the creation of user-defined fields that, once created are available in various master data records, such as Items, Vendors, Ship-To-Comapnies and many others. These fields allow companies to enter and store information outside of the fields provided in the system. User fields can also be used in connection with User Calculations to and are available for printing on the majority of Part Forms and Report Layouts throughout the system.

Location Types

Location Types define and link the types of Locations available in each of the existing Facilities. Each Location Type requires a unique name and those that exist in multiple Facilities, like Tanks and Racks, should be given names that tie to the Facilities in which they are located. Users with access to the Inventory Maintenance menu will have access to add and modify Location Types. Rules for re-naming existing Location Types follow the same rules as Locations in that Deacom drives from the Location Type ID and not the name.

System Navigation

  • Inventory > Maintenance > Location Types

Edit Location Type form

Opened via the "New" or "Modify" button on the Location Types form.

General tab

Field/Flag

Description

Name

Defines the name of the Location Type, which must be unique.

Negative Inventory

Pick list used to set negative inventory options this level. Options are: Always, Follow Part, Never, Once.

  • This setting at the Location Type level takes precedence over the "Negative Inventory" setting on the Facility and Part, unless it is set to "Follow Part".
  • Useful for situations in which customers need the ability to turn off negative inventory by Facility, but still keep it on at the Location Type/Location level.
  • If customers are using strict lot control, allowing items to go negative is not advisable.

Facility

Search field used to select the Facility to which this Location Type will belong. When changing the Location Type's Facility on this form and saving the form, the system will check to see if there is any inventory with the location type still associated to it. If there is, the system will display the following prompt: "This location type cannot change facilities while there is still inventory associated with it."

Active

If checked, this record is active. Only active records may be used in the system.

Default

If checked, this Location Type will populate when the Facility selected in the field above is identified on forms requiring a Location Type. 

Prevent Inventory Transactions

If checked, posting or relieving of inventory will be prevented for this Location Type (and therefore the corresponding Locations within this Location Type), with the exception of physical inventory postings.

  • When using this flag in connection with physical inventories, the system will ensure that no transactions occur between the time the inventory snapshot is taken and the time when the Physical Inventory Worksheet is posted.
  • If a user attempts to perform an inventory transaction in the system for the Location Type, a system prompt will be displayed to prevent the transaction from occurring.
  • This flag also exist on Item Master records, Locations, Facilities, and Zones.

Deacom allows the creation of user-defined fields that, once created are available in various master data records, such as Items, Vendors, Ship-To-Comapnies and many others. These fields allow companies to enter and store information outside of the fields provided in the system. User fields can also be used in connection with User Calculations to and are available for printing on the majority of Part Forms and Report Layouts throughout the system.

Locations

Locations are used throughout the system to indicate both where inventory is located and where items will be placed as a result of various inventory actions, such as receiving a Purchase Order or finishing production on a Job. On all forms where inventory is put away into Locations, a pair of search fields for Location Type and Location will be displayed and must be filled in by the user. The default values for these search boxes may come from the Item Master General tab or the Facility Part Cross Reference (if one exists), if these tabs contain values, or the records flagged as default. Users with access to the Inventory Maintenance menu will have access to create and modify Locations. Rules for re-naming existing Locations follow the same rules as Location Types in that Deacom drives from the Location Type ID and not the name.

System Navigation

  • Inventory > Maintenance > Locations

Edit Location form

Opened via the "Add" or "Modify" buttons on the Locations form. Note that the Locations form contains a display field with options to select Active, Inactive, of Both Locations.

General tab

Field/Flag

Description

Name

Displays the name of the Location, which must be unique.

  • A blank value for location is not allowed, but the use of the name “None” is valid.

Description

Displays a description of the Location.

Location Type

Search field used to select the Location Type to which this Location belongs.

  • Multiple Locations may be linked to one Location Type.

Capacity Unit (requires WMS license)

Search field used to define the Unit used to measure the Capacity quantity, with the most common usage being cubic feet.

  • Used in connection with the "Capacity" field to support Directed Put Away.

Capacity (requires WMS license)

Defines the maximum quantity of inventory that the Location can hold.

  • Used in connection with the "Capacity Unit" field to support Directed Put Away.

Replenishment Min.

Used in conjunction with Movement Rules to dictate when a Location is considered for replenishment. Priority for Location replenishment is determined by the sort rules on the rule used.

Location Sequence

Determines the sequence the system will use when determining where material should be placed or selected from when issuing.

  • The sequence is used to determine where material should be placed when used in connection with the "Putaway" function in the WMS application. Putaway logic: Once the "Putaway" button is clicked, the system will start with the default Location on the Item Master to see if there is enough space in that Location to store the Lot. If there is not enough room, the system will check each Location beginning with the next "Location Sequence" number listed after the default Location. Example: If the default Location has a "Location Sequence" of 50 and there is not enough room, the system will look for a "Location Sequence" of 51 and so on until a Location with sufficient room is found.
  • The sequence is used to determine where to select material from when using the Location Priority optimize option on the Issue/Reserve form. When using this option the system optimizes lots by finding the first expiring lot for each part in each Location, beginning with the Location that has the lowest "Location Sequence" value.

Last Count

Displays the date that inventory in this Location was last counted, via the posting of a Physical Inventory Worksheet, at any Facility, regardless of how many Facilities may be linked via the Item Master Facilities tab.

  • The inventory/lots that were counted is based on how the Physical Inventory Worksheet was filtered and then posted. It does not necessarily indicate that all inventory lots in this Location were counted on the date indicated.

Active

If checked, this record is active. Only active records may be used in the system.

  • After inactivating Locations, have the scanner users log out then back in to Deacom to refresh the Locations available for use.

Default

If checked, this Location will be default for the Location Type specified. This default will populate when the appropriate Location Type is identified on forms requiring a Location entry. 

Prevent Inventory Transactions

If checked, posting or relieving of inventory will be prevented for this Location, with the exception of physical inventory postings.

  • When using this flag in connection with physical inventories, the system will ensure that no transactions occur between the time the inventory snapshot is taken and the time when the Physical Inventory Worksheet is posted.
  • If a user attempts to perform an inventory transaction in the system for the Location Type, a system prompt will be displayed to prevent the transaction from occurring.
  • This flag also exist on Item Master records, Location Types, Facilities, and Zones.

Deacom allows the creation of user-defined fields that, once created are available in various master data records, such as Items, Vendors, Ship-To-Comapnies and many others. These fields allow companies to enter and store information outside of the fields provided in the system. User fields can also be used in connection with User Calculations to and are available for printing on the majority of Part Forms and Report Layouts throughout the system.

Movement Rules

Movement rules are used to define how inventory will be picked and what in order when handling location replenishment for sales order fulfillment.

System Navigation

Inventory > Maintenance > Movement Rules

Movement Rule form

Edit Movement Rule form

Opened via the "Add" or "Modify" button on the Movement Rule form.

Button/Field

Description

Rule Name

Enter appropriate name.

Transaction Type

Choose Location Replenishment or Sales Order

Facility

 

From Zone

 

Active

Check to make the rule active.

Require Specific Sales Order

 

Sort Rule Add form

Opened via the "Add" or "Modify" button on the Edit Movement Rule form.

Button/Field

Description

Sort By

 

Expression

Available when selecting a Sort By value of "User-defined."

MRP Groups

MRP Groups may be assigned to items that share similar characteristics via the Item Master MRP tab. This feature is designed so that when the "Create Job" button is used in MRP, all items belonging to the same MRP Group will be added to the same production Job.

  • This feature should not be used if the "Create Separate MRP Job" flag is checked on a Part's Item Master Properties tab.
  • If all items are selected and the "Create Job" button is used, all items without an MRP Group will be placed together on a single Job.

System Navigation

  • Inventory > Maintenance > MRP Groups

Edit MRP Group form

Opened via the "New" or "Modify" buttons on the MRP Groups form.

Field/Flag

Description

Name

Displays the name of the MRP Group

Active

If checked, this record is active. Only active records may be used in the system.

Part Exclusions

Part Exclusions may be used to prevent users from selecting and selling items from certain Facilities or to certain Customers during Sales Order entry. Part Exclusions set at the Facility level take precedence over those set at the customer level and only block the sale of items and not the manufacture and purchase of items. 

Users with access to the Inventory Maintenance menu will have access to create and modify Part Exclusions. The security setting "Sales orders -- override restricted selling" overrides the Part Exclusion block and allows users to both view and select items assigned to Part Exclusions. In this case, the system will display a prompt indicating the Part is assigned to a Part Exclusion and ask the user if they wish to continue.

System Navigation

  • Inventory > Maintenance > Part Exclusions

Edit Part Exclusion form

Opened via the "New" or "Modify" buttons on the Part Exclusions form.

Field/Flag

Description

Name

Displays the name of the Part Exclusion, which must be unique.

Active

If checked, this record is active. Only active records may be used in the system.

Put Away Rules

*Access to this form requires the WMS license.

Companies can use Put Away Rules to dictate how inventory can be physically put away in a warehouse. These rules may then be used for a company to automatically determine the nearest suitable Location in which they can put away a given item. Utilizing the Put Away Rule framework, companies will be able to create a rule for a given Part Number, choose specified Location overrides (if they need to stack an item lower than a Location would normally allow, for instance), specify the sort methodology they wish to use, set Existing Inventory to Same Part Number so that only like parts may go together in a non-empty Location, set Lot Number to Same so that only like Lots may go together in a non-empty Location, etc.

Additional features allow companies to apply this rule to not just a single Part, but to a Sub-Category, Category, Item Search 1-5 field, or all Parts for easy setup. There is also the ability to allow/disallow placing an item in a Location based on the Inventory Segment or QC Status of items already in place. These rules will apply real-time in the WMS system and once set up, require no intervention from the user other than an item scan.

Once the fields of the form are set - specifically, the "To Type" and "Facility/Location/Location Type" fields - the Location Sort section of the form will populate with the Locations deemed valid by the warehouse hierarchy defined in the system. For example, if a Put Away Rule is configured for a Facility, then the rule will apply to all Locations that belong to that Facility. If a Put Away Rule is configured for a specific Location, then the rule will only apply to that Location, but not be limited to only that Location within one Facility or Location Type. This is helpful in situations where one Location, such as a Freezer, exists in multiple Facilities, and the same Put Away Rule should apply to all Freezers.

Put away location suggestion logic

Once Put Away Rules are created, the put away location suggestion logic fundamentally consists of checking a Location for suitability with a number of disqualifying tests. Once Deacom finds a Location to potentially use, and if that Location passes all tests, then it is used as the put away location. If it fails any test, then the logic proceeds to the next possible Location and repeats the tests. A visual representation of this process is also included for reference. Note: For all sorting behaviors described below, Locations are first sorted by the Location Sequence number. If there is a tie, they are then sorted by the Location's Name.

Location suitability check

  • Check for relevant rule:
    • The system determines if there is a relevant Put Away Rule specifically for the Part Number being put away (i.e. a Put Away Rule with a "For Type" of "Part Number" and "For" with that Part Number's ID). If such a rule exists, it is used.
    • If no such rule exists, the system looks for a Put Away Rule for the Part Number's Item Search 1-5 field (i.e.a Put Away Rule with a "For Type" of one of the Item Search 1-5 fields and with that fields Item Search ID). If such a rule exists, it is used.
    • If no such rule exists, the system looks for a Put Away Rule for the Part Number's Sub-Category (i.e. a Put Away Rule with a "For Type" of "Sub-Category" and "For" with that Part Number's Sub-Category ID). If such a rule exists, it is used.
    • If no such rule exists, the system looks for a Put Away Rule for the Part Number's Category (i.e. a Put Away Rule with a "For Type" of "Category" and "For" with that Part Number's Category ID). If such a rule exists, it is used.
    • If no such rule exists, the system looks for a Put Away Rule for "All Part Numbers". If such a rule exists, it is used.
    • If no such rule exists, the system follows the logic in "Default Behavior" described below.
  • Determine starting Location:
    • If the form being used to move/receive material contains a "Location" field that is populated, the Location is used.
    • If no such field exists, the system checks for Locations in the Location Sort section of the Put Away Rule. If one or more are found, the Location with the lowest Sequence number is used.
    • If no such records exist, the system looks for the "Default Location" selected on a Facility Part Cross Reference for the Facility and Part selected, if one exists. If one is found, it is used.
    • If no such records exist, the system looks for the "Default Location" selected on the Part's Item Master General 1 tab. If one is specified and belongs to the current Facility, it is used.
    • If no such default exists, the system looks for the current Facility's default Location Type then looks for that Location Type's default Location. That Location is then used as the starting Location.
  • Default Behavior (no applicable Put Away Rule was found):
    • The system finds the closest Location with available capacity. Beginning with the starting Location, the system determines if that Location has enough available capacity. If it does, that Location is used as the recommended put away location.
    • If that Location does not have sufficient capacity, the system checks the Location one below the starting Location. If that Location has enough available capacity, it is used.
    • If that Location does not have sufficient capacity, the system checks the Location one above the starting Location (therefore two above the previous Location checked). If that Location has enough available capacity, it is used.
    • If that Location does not have sufficient capacity, the system continues with the following pattern, where "start" indicates the starting Location: [start], [start] -1, [start] + 1, [start] -2, [start] + 2, [start] -3, etc. until a suitable Location is found and returned.
    • If no suitable Location is found, the system will prompt the user.
  • Directed Put Away Behavior (an applicable Put Away Rule was found):
    • The system finds the closest Location with available capacity. Beginning with the starting Location, the system determines if that Location has enough available capacity. If it does, that Location is used as the recommended put away location.
    • If that Location does not have sufficient capacity, the system uses the "Sort" pattern selected on the Put Away Rule (described in the "Sort" field description below) to check each Location from the relevant list of Locations found for sufficient capacity.
    • Determine list of relevant Locations:
      • If there are Locations listed in the Location Sort section of the Put Away Rule being used, those records and corresponding Sequences are used as the list of relevant Locations. If one or more are found, the Location with the lowest Sequence number is used.
      • If there are no Locations listed in the Location Sort section of the Put Away Rule being used, the system uses the list of active Locations, found in Inventory > Maintenance > Locations, and their corresponding "Location Sequence" values.
  • When each Location is checked, all of the following disqualifying tests are run. If the Location passes all tests, it is used as the recommended put away Location. If not, the system continues on to the next Location using the above logic.

Disqualifying tests

  • "To" test:
    • If this Location resides within the "To" place as defined in "To Type" and "To" fields on the Put Away Rule, then this test passes.
  • "Capacity" test:
    • If "Capacity Type" is set to "Amount" on the applicable Put Away Rule, then use the capacity values from that rule for the Location Capacity for the calculation specified below.
    • If "Capacity Type" is set to "Percent", then multiply the "Capacity" defined on the Location record by the "Capacity" value defined on the rule and divide by 100. Use this value for the Location Capacity.
    • If "Capacity Type" is set to "From Location", then use the maximum capacity of the Location for this test, defined by the "Capacity" field on the Location record: Take everything already in this Location, and convert the item quantities to the Location's defined "Capacity Unit", then sum. Location capacity minus this value is remaining capacity. Determine capacity value of quantity to be put away by converting capacity units. If this value is less than or equal to remaining capacity, then the material can be placed in this Location and this test passes.
  • "Existing Inventory" test:
    • If "Existing Inventory" is set to "Any" on the applicable Put Away Rule, then this test passes.
    • If "Existing Inventory" is set to "None", then this Location only passes if it has no inventory in it already.
    • If "Existing Inventory" is set to "Same Category", then this Location only passes if (1) all inventory already in it belongs to the same Category as the Part Number being put away or (2) it is empty.
    • If "Existing Inventory" is set to "Same Sub-Category", then this Location only passes if (1) all inventory already in it belongs to the same Sub-Category as the Part Number being put away or (2) it is empty.
    • If "Existing Inventory" is set to "Same Part", then this Location only passes if (1) all inventory already in it is the same Part as the Part Number being put away or (2) it is empty.
  • "Inventory Type" test:
    • If "Inventory Type" is set to "Any" on the applicable Put Away Rule, then this test passes.
    • If "Inventory Type" is set to "Same", then this Location only passes if (1) all inventory already in it is part of the same inventory segment as the Part Number being put away (2) it is empty.
  • "QC Status" test:
    • If "QC Status" is set to "Any" on the applicable Put Away Rule, then this test passes.
    • If "QC Status" is set to "Same", then this Location only passes if (1) all inventory already in it has the same QC Status as the Part Number being put away or (2) it is empty.
  • "Lot Number" test:
    • If "Lot Number" is set to "Any" on the applicable Put Away Rule, then this test passes.
    • If "Lot Number" is set to "Same", then this Location only passes if (1) all inventory already in it has the same Lot Number as the Part Number being put away or (2) it is empty.
  • If all tests pass, then return this as the recommended put away location. If not, the system continues on to the next Location using the logic described earlier.

System Navigation

  • Inventory > Maintenance > Put Away Rules

Edit Put Away Rule

Opened via the "New" or "Modify" buttons on the Put Away Rules form.

Button/Field/Flag

Description

Same As

Allows the user to use a previously created Put Away Rule as a base for a new one.

For Type

Pick list used to determine to what the rule applies. Options are:

  • All Part Numbers - Rule applies to all Parts.
  • Category - Rule applies to all Parts that belong to the selected Category.
  • Part Number - Rule applies to the selected Part Number.
  • Item Search 1-5 - Rule applies to the selected Item Search value.
  • Sub-Category - Rule applies to all Parts that belong to the selected Sub-Category.

Category/Part Number/Sub-Category/Item Search 1-5

Search field used to select the applicable Category, Part Number, Sub-Category or Item Search 1-5 that this rule applies to.

  • Field caption changes based on the "For Type" selected.

To Type

Pick list used to determine where the rule applies.

  • All Locations - Rule applies to all Locations.
  • Facility - Rule applies to the selected Facility.
  • Location - Rule applies to the selected Location.
  • Location Type - Rule applies to the selected Location Type.

Facility/Location/Location Type

Search field used to select the applicable Facility, Location, or Location Type that this rule applies to.

  • Field caption changes based on the "To Type" selected.

Capacity Type

Pick list used to determine if the rule is subject to a specific capacity, and if so whether the capacity limit is amount from location, a specific absolute amount for this rule, or a percentage of total location maximum capacity.

  • Amount - The material being received/moved may only occupy the amount of space specified by the "Capacity" field on this form, which is measured in the "Capacity Unit" specified on this form.
  • From Location - The material being received/moved may only occupy the "Capacity" defined on the record of the Location the material is being moved from.
  • None - The material being received/moved is not subject to a specific capacity.
  • Percent - The material being received/moved may only occupy a percent, as specified by the "Capacity" field on this form, of the "Capacity" defined on the record of the Location to where it is being received/moved.

Capacity Unit

The Unit in which the "Capacity" is measured, when "Capacity Type" is set to "Amount".

Capacity

The specific absolute amount or percentage of total location maximum capacity that may be consumed by the material.

Active

If checked, this record is active. Only active records may be used in the system.

Fill Partial Location Prior To Empty Location

If checked, the system will look for and suggest to fill a location that meets both of the two criteria below.

  • Location that already has inventory that matches the Put Away Rule criteria.
  • Location that has capacity

In this case, the system will attempt to fill the location to capacity before trying to fill closer locations. This flag is unchecked by default.

Sort

Pick list used to determine how Locations are sorted when the system is iterating through the options to suggest one for use. Options are:

  • Ascending - Locations are evaluated in ascending order based on the Location Sequence defined in the rule (e.g. [start], [start] + 1, [start] + 2, etc.). When highest Location is reached, wrap back to lowest Location and keep checking until all checked.
  • Closest - Locations are evaluated in order using the Location Sequence defined in the rule and based on which one is closest to the starting Location (e.g. [start], [start] - 1, [start] + 1, [start] - 2, [start + 2], [start -3], etc.).
  • Descending - Locations are evaluated in descending order based on the Location Sequence defined in the rule (e.g. [start], [start] - 1, [start] - 2, etc.). When lowest Location is reached, wrap back to highest Location and keep checking until all checked.

Existing Inventory

Pick list used to determine if the material being received/moved can be mixed in with other Parts, or segregated based on Category, Sub-Category, etc. Options are:

  • Any Parts - The destination Location may contain any Parts.
  • None - The destination Location must be empty.
  • Same Category - The destination Location may only contain Parts that belong to the same Category as the Part being received/moved, as defined on the Part's Item Master General 1 tab.
  • Same Part - The destination Location may only contain the same Part that is being received/moved.
  • Same Sub-Category - The destination Location may only contain Parts that belong to the same Sub-Category as the Part being received/moved, as defined on the Part's Item Master General 1 tab.

Inventory Type

Pick list used to determine if the material being received/moved can be mixed in with material classified as a different Inventory segment. Options are:

  • All - The destination Location may contain material in any inventory segment (Inventory, Quarantine, Staging, etc.).
  • Same - The destination Location may only contain material that is classified in the same inventory segment as the material being received/moved.

QC Status

Pick list used to determine if the material being received/moved can be mixed in with material classified as a different QC status. Options are:

  • All - The destination Location may contain material in any QC status (Approved, At-Risk, Pending QC, etc.).
  • Same - The destination Location may only contain material that is classified in the same QC status as the material being received/moved.

Lot Number

Pick list used to determine if the material being received/moved can be mixed in with material labeled with a different Lot Number. Options are:

  • All - The destination Location may contain multiple Lots of material with varying Lot Numbers.
  • Same - The destination Location may only contain material that is labeled with the same Lot Number.

Sort

Allows the user to sort the order in which the available Locations, as listed in the Location Sort section of the form, are suggested when a user is putting away inventory.

Quality Control Groups

Quality Control is a major method of providing process control within Deacom. Quality Control ensures that required Quality Control Tests are performed when Raw Materials are received on Purchase Orders, when Finished Goods are produced on production Jobs, and when previously sold products are returned. Quality Control is an optional feature with a wide array of applications ranging from completely turned off to extremely strict requirements, and is established on an item by item basis. This means that some items can have absolutely no quality control, while others can have many required QC tests.

Quality Control Tests are required to do QC testing. The Quality Control Test describes the base name of the test as well as any applicable testing methods and the Unit of Measure that should be used for testing. Quality Control Groups are a list of sequenced Quality Control Tests for the group to perform. QC Groups can be attached to a Part's Item Master to indicate testing required upon PO receipt or on a Bill of Materials to indicate testing required prior to, or following, finishing of material on a production Job. If two items have identical QC Tests and allowable results, they can share the same QC Group. If two items have different QC Tests or different allowable results, they would each have a different QC Group. A system can have as few as one QC Group, or as many QC Groups as there are items, or anything in between. Items may also have multiple QC Groups assigned based on different testing levels. For example, all Raw Materials may be assigned a basic QC Group, with a certain sub set of Raw Materials being assigned an additional QC Group on the Item Master record to ensure these materials undergo additional QC testing requirements.

Quality Control Security Groups are assigned to each Quality Control Test when the test is added to a Quality Control Group. User Groups are then assigned to QC Security Groups using Quality Control Group Security. This grid must be updated whenever a new Quality Control Security Group or User Group is created to ensure the new group has appropriate access. Specific test protocols and security for entering QC data are configured via Quality Control Groups and security for who can enter QC values is configured via Quality Control Security Groups. Additional system security is required to perform functions such as creating or modifying QC Tests and QC Security Groups.

QC approval process and security options

Quality control results may be entered without requiring approval before users may click the "Finish QC" button and place items into regular inventory or failed QC inventory. The QC approval process involves the ability to review and indicate final approval for those QC groups that require this check and also the ability to approve individual QC results that are out of spec for manufactured items. Several different security options and features are available to ensure QC results are validated.

General QC approval

The ability to require QC approval is determined by the "Approval Type" field on the QC Group. If this field is set to any value other than "None", a separate approval step is required in addition to entry of test results to indicate final approval or rejection of the tested material. In addition, users will be unable to use the "Finish QC" button when performing testing until the "Approve QC" flag has been checked on the Quality Control Results form. Security exists to control access to Approve QC.

E-Signature approval

The "Require E-Signature For Approval" and "Require E-Signature For Results" flags are available to each Quality Control Group. If checked, a valid Deacom username and password is required to be entered before the “Finish QC” step is allowed or before a QC pass may be entered. A record of this approval is stored in Deacom in an encrypted record (AES-256 encryption like the rest of the system). The Deacom application complies with the FDA requirement (21 CFR 11) for E-Signatures by employing at least two distinct identification components, namely a username and password as indicated in Section 11-200 of the Code of Federal Regulations. Note: Multiple e-signatures may be required for each QC pass via the "e-Signatures Counts" fields.

Approving out of spec QC results

A QC result is considered within specification if the result is between the minimum and maximum values defined on the test. The "Must Pass QC To Continue" flag is an optional setting located on each QC item within the QC group. If this flag is checked, the QC result must be between the minimum and maximum values before the material can be accepted into regular inventory. Security exists that allows users to approve QC results when the results are out of specification. This security is used in connection with the Approve QC security mentioned above.

System Navigation

  • Inventory > Maintenance > Quality Control Groups

Edit Quality Control Group form

Opened via the "New" or "Modify" button on the Quality Control Groups form, the Edit Quality Control Group form is used to group together Quality Control Tests that should be performed on a given Part. Information pertaining to the group is configured using the General and User Fields tabs and all QC Tests belonging to the group are listed on the bottom of the form. A couple notes regarding QC Groups include:

  • The "un_name" column, which displays the QC Unit of Measure (if populated) is available to this form.
  • The "Require E-Signature When Saving A QC Group" flag on the System > Options > Inventory tab will prompt and require a user to enter valid credentials before modifying a QC Group.
  • When modifying an existing QC group, including QC tests on the group, the system checks to see if there are open jobs using this QC Group or if there are lots in Pending QC using this QC Group that have QC values already entered.
    • If open jobs are found with the QC Group, the system will prompt users asking if they wish to the update the QC Group on these jobs.
    • If there are lots in Pending QC using this QC Group that have existing QC values, then the system will list the affected lots, and prompt users that these lots will have their QC values removed and if they wish to Continue. If users choose to continue, QC values will have to be reentered for the affected lots.

Button

Description

Same As

Allows the user to copy an existing Quality Control Group to use as a base for the one being created.

  • Used Field values, if present, will be copied to the newly created Quality Control Group.

Add

Opens the Edit Quality Control Item form, which is used to add a Quality Control Test to the group and assign values and other qualities.

Modify

Opens the Edit Quality Control Item form, which is used to modify the selected Quality Control Test.

Delete

Deletes the currently selected Quality Control Test.

Sort

Allows the user to sort the order of the Quality Control Tests listed.

General tab

Field/Flag

Description

QC Group Name

Defines the name of the group.

Days Open

Indicates the number of days after production that QC entry is allowed.

Approval Type

Pick list used to indicate when and how approval is required. Options are:

  • All - Approval is required for all tests in the group, regardless if the tests are within range, passed, or failed.
  • Failed - Approval is required only when tests in the group fail the testing parameters.
  • None - Approval is not required for this group.

Approval overrides failed tests that are flagged as “Must Pass QC To Continue”. Rejection sends material into Failed QC status, where only approved users have access to it.

E-Sig Approval Type

Pick list used to indicate when and how E-Signatures are required. Introduced in 15.03.072 and replaces the "Require E-Signature For Approval" flag. Options are:

  • All - An E-Signature is required for all tests in the group, regardless if the tests are within range, passed, or failed. Only available when "Approval Type" is set to "All".
  • Failed - An E-Signature is required only when tests in the group fail the testing parameters. Only available when "Approval Type" is set to "All" or "Failed".
  • None - An E-Signature is not required for this group.

QC Approval E-Signature Counts

Only used when approving QC to determine how many e-signatures are required. Option to require, and store, multiple e-signatures when approving QC. If the number in this field is greater than 1, the system will display a signature form, requiring an entry, for the number specified in this field.

  • Only enabled when the E-Sig Approval Type is not set to "None:.
  • Text field with a mask of "9"
  • When the E-Sig Approval Type is set to All or Failed, the value is this field will default to 1.
  • Business Case: - useful for tight quality control processes where an employee and supervisor e-signature is required on QC results.
  • Notes:
    • If multiple e-signatures are required, all must be completed, or no e-signature's will be entered/stored in the system.
    • The enforcement of different credentials per QC Group only is applied when the value in this field is greater than 1. So, for example: If approving quality control results, and there are two QC groups involved, each with an Approval E-Signature Count of "1" in this field, the same approver credentials can be used to sign off on each QC Group.

QC Results E-signature Counts

Used to determine how many e-signatures are needed to enter results. 

  • Enabled only when 'Require E-Signature For Results' is true.

Active

If checked, this record is active. Only active records may be used in the system.

Default

This flag is not used for Quality Control Groups and therefore has no purpose if checked. It is listed only because it is a standard field on forms.

Complete Empty Tests

If checked, the system will complete empty tests with empty values and move them to QC list/values form. If not checked, the system will only move tests that have values to the QC list/values form.

  • Checking this flag is useful in situations where QC will be performed incrementally on Jobs since users will be able to enter QC via the Close/Relieve form without having to go back to the first pass of QC results and enter values for tests not completed in that pass.

Require E-Signature For Approval

If checked, a valid Deacom username and password is required to be entered before the “Finish QC” step is allowed.

  • Replaced with the "E-Sig Approval Type" pick list.
  • A record of this approval is stored in Deacom in an encrypted record (AES-256 encryption like the rest of the system).
  • The Deacom  application complies with the FDA requirement (21 CFR 11) for E-Signatures by employing at least two distinct identification components, namely a username and password as indicated in 21 CRF 11.200.
  • If checked, the "Approval Type" field will automatically be set to "All".
  • If results for a test with this flag checked are entered then modified, the user will be prompted to add a new e-signature for the modified results.

Require E-Signature For Results

If checked, a valid Deacom username and password is required to be entered when applying each pass of QC results.

  • A record of this approval is stored in Deacom in an encrypted record (AES-256 encryption like the rest of the system).
  • The Deacom application complies with the FDA requirement (21 CFR 11) for E-Signatures by employing at least two distinct identification components, namely a username and password as indicated in 21 CRF 11.200.
  • If checked, the "Approval Type" field will automatically be set to "All".

Do QC After Production

If checked, QC is performed after production.

  • Valid only for groups pertaining to produced, not purchased material.
  • Finished material is put into QC Hold status, pending test results.

Approval Required

If checked, approval is required for the QC results to be posted.

Copy Vendor/Pre-Production QC

If checked, and the “Retain QC” field on the Vendor's General tab is set to “Same Part” or “All”, then the system will automatically populate the QC results when receiving the sameUser Lot for items from this Vendor.

  • Useful in situations where companies trust the Vendor's products and QC process.
  • Example: Assume a Vendor has "Retain QC" set to "Same Part" and the QC group has this flag checked. Part 123 is received with a Vendor Lot of "ABC" today and the same item and Lot is also received tomorrow. The user will be prompted to copy QC results when the “Receive” button is clicked on the PO. Once this happens, the Lot goes right into inventory and by-passes QC. The user can still choose a Location in inventory if it is not retained.
  • The security option "Purchasing -- Select lots when copying QC" works with this feature. When set to no, the system will not show the lot selection mover form when copying QC results. This option is useful in situations where customers do not want the employees receiving the product to be making the decision on what QC values to copy.
  • Systematically, if this flag is checked and
    • The QC Group is set on the Item Master, the copy vendor QC functionality will be used.
    • The "Do QC After Production" flag is not checked, and the QC Group is set on the Formula, the copy pre-production QC functionality will be used.
    • The "Do QC After Production" flag is checked, and the QC Group is set on the Formula, QC will not be copied since it is occurring after production.
    • The "Do QC After Production" flag is checked, and the QC Group is set on the Item Master, the copy vendor QC functionality will be used.
  • Additional requirements that are supported by checking or not checking this flag:
    • Check this flag for products when, once QC approves the job (right labels, containers, etc.) the production team can finish as many pallets as needed.
    • Uncheck this flag for products when every single finish/pallet needs its own in-process QC approval before being finished. Another option for QC release of individual pallets is post-production QC.

Fail To Quarantine

If checked, Lots that fail QC testing will automatically be failed to the Quarantine inventory segment.

  • Specifically, functionality has been added on the QC results form to put the Lot into Quarantine if the results are being failed and if any Test in a Group flagged with "Fail To Quarantine" failed.
  • Users with approval can then access Quarantine and determine if the material can be used or scrapped.
  • This feature was added to allow users to produce material via Input Production and have the inventory automatically go to Quarantine. There, a QC Manager may determine if it can be used or needs to be scrapped.

User Fields tab

Deacom allows the creation of user-defined fields that, once created, are available on various master data records such as items, Vendors, and Ship-to Companies. These fields allow companies to enter and store information outside of the fields provided in the system. User fields may be added via Tools > Tools Maintenance > User Fields.  

  • Note: QC Test user fields can be added to the Edit Quality Control form

Work Flow tab

Work Flows, managed via Tools > Maintenance > Work Flows, that are assigned to a QC Group are the associated Sequences that must be completed before it is considered complete. This requires the permission "Quality control -- edit QC Group work flow level 0-9" in Edit User Access to add a Work Flow to a QC Group. A search box with applicable Work Flows allows the user to add the desired Work Flow to the QC Group.

Edit Quality Control Item form

Opened via the "Add" or "Modify" buttons on the Edit Quality Control Group form, the Edit Quality Control Item form is used to manage Quality Control Tests within a Quality Control Group and assign values and other qualities. A few notes regarding the values specified in this form:

  • The "Min Value" must be less than the "Max Value", unless the max is 0.
  • Tests may be created with a minimum and no maximum, in which case QC results will pass if the result is greater than the minimum and the maximum is set to 0.
    • Example: Assume a test has a minimum of 10 and a maximum of 0. The system will enforce only that the result must be greater or equal to the minimum.
  • Numbers must be used to accommodate situations where a test result needs to be expressed as "Yes" or "No", "True" or "False", or "Pass" or "Fail".
    • In these cases, 0 represents no/false/fail and 1 represents yes/true/pass.
    • To enable this option, users may set the minimum and maximum values both to 1.0, in which case 1.0 means yes and any other value means no.
    • A "9" may also be added to the "Input Mask" field to ensure only one number is entered for the test result.

Field/Flag

Description

Quality Control Test

Search field used to select a Quality Control Test to add to the group.

QC Test Group

Search field used to select the Quality Control Security Group that applies to this test.

Description

Displays a description of the test, up to 200 characters.

Target Value

Memo field used to indicate the target value for the test.

  • Both numeric and non-numeric test results are allowed.
  • Maximum length is 120 characters.

Default Value

Optional, set the default QC Test value in a QC Test setup which will populate by default. Useful if have many simple/optional QC Tests to lessen the burden of entry.

Min Value

Indicates the minimum accepted value for the test. 

Max Value

Indicates the maximum accepted value for the test.

Min Detectable

Indicates the default value for a minimum detectable reading, generally used for legal requirements.

  • Testers can indicate an amount was evident but below the stated detectable level for the test, the testing equipment, or both when entering QC results.

Print Mask

Field used for formatting the QC results on forms. When the Print Mask is not used, the Input Mask will be the fallback field used for formatting the QC Results on forms. Input Mask and Print Mask can be used together when users should enter results with 4 decimals, but only display 3 decimals. 

  • Example: If results should always be displayed with 3 decimals, the value in this field should be “9.999”.

Input Mask

Defines the mask, which governs the format, that will be used when entering the results.

  • Example: If results should always be 4 digits long, the value in this field should be "9999".

Aggregate Type

Pick list used to select which QC value, when multiple iterations of a test are performed, will populate on Part Forms. Options are:

  • Average - The average of all values entered for this test will be used.
  • Last - Most commonly used. The last value entered for this test will be used.
  • Max - The highest value entered for this test will be used.
  • Min - The lowest value entered for this test will be used.

Notes

Memo field used to store notes regarding the test.

  • Notes will be retained when shipping and receiving an Inter-Company Transfer.

Required

If checked, a value must be entered for this test prior to moving the item to inventory.

  • This flag indicates that a value must be entered; it does not indicate that the value entered must be a passing value.
  • This means that the validation that all required tests have been completed occurs for pre-production QC at the time of a finish.
  • For post production QC, the validation occurs when the results are finished via Production > QC Result Entry.

Must Pass QC To Continue

If checked, a value entered for this test must be between the minimum and maximum defined.

  • For tests set with a minimum but no maximum, results will pass if the result is greater than the minimum and the maximum is set to 0.

Print On Forms

If checked, the test description, values, and notes will be available for display on Part Forms, including Certificates of Analysis.

  • When checked, the "Required" and "Must Pass QC To Continue" flags will usually also be checked since Certificates of Analysis will primarily display required tests with passing results indicated.

Prints On POs

If checked, the test description, values, and notes will be available for display on Purchase Orders.

  • This allows companies to display/communicate the QC parameters that will be utilized.
  • Even if this flag is checked, the appropriate fields will still need to be added to the appropriate Part Forms and Report Layouts in the system.

Require Notes

If checked, users will be required to enter notes for this test, via the "Edit Notes" button on the Edit QC Results form, before results can be saved/applied.

  • Useful in situations where additional, critical notes, must be entered on a test.
  • The "Result Notes" field on the Modify QC Result form will be displayed in blue when this flag is checked to better alert users when multiple QC Tests are present.

Quality Control Security Groups

Quality Control is a major method of providing process control within Deacom. Quality Control ensures that required Quality Control Tests are performed when Raw Materials are received on Purchase Orders, when Finished Goods are produced on production Jobs, and when previously sold products are returned. Quality Control is an optional feature with a wide array of applications ranging from completely turned off to extremely strict requirements, and is established on an item by item basis. This means that some items can have absolutely no quality control, while others can have many required QC tests.

Quality Control Tests are required to do QC testing. The Quality Control Test describes the base name of the test as well as any applicable testing methods and the Unit of Measure that should be used for testing. Quality Control Groups are a list of sequenced Quality Control Tests for the group to perform. QC Groups can be attached to a Part's Item Master to indicate testing required upon PO receipt or on a Bill of Materials to indicate testing required prior to, or following, finishing of material on a production Job. If two items have identical QC Tests and allowable results, they can share the same QC Group. If two items have different QC Tests or different allowable results, they would each have a different QC Group. A system can have as few as one QC Group, or as many QC Groups as there are items, or anything in between. Items may also have multiple QC Groups assigned based on different testing levels. For example, all Raw Materials may be assigned a basic QC Group, with a certain sub set of Raw Materials being assigned an additional QC Group on the Item Master record to ensure these materials undergo additional QC testing requirements.

Quality Control Security Groups are assigned to each Quality Control Test when the test is added to a Quality Control Group. User Groups are then assigned to QC Security Groups using Quality Control Group Security. This grid must be updated whenever a new Quality Control Security Group or User Group is created to ensure the new group has appropriate access. Specific test protocols and security for entering QC data are configured via Quality Control Groups and security for who can enter QC values is configured via Quality Control Security Groups. Additional system security is required to perform functions such as creating or modifying QC Tests and QC Security Groups.

System Navigation

  • Inventory > Maintenance > Quality Control Security Groups

Edit QC Security Group form

Opened via the "New" or Modify" buttons on the Quality Control Security Groups form.

Field/Flag

Description

Name

Displays the name of the security group.

Active

If checked, this record is active. Only active records may be used in the system.

Default

If checked, this security group is the default for new Quality Control Tests added to Quality Control Groups.

Quality Control Tests

Quality Control is a major method of providing process control within Deacom. Quality Control ensures that required Quality Control Tests are performed when Raw Materials are received on Purchase Orders, when Finished Goods are produced on production Jobs, and when previously sold products are returned. Quality Control is an optional feature with a wide array of applications ranging from completely turned off to extremely strict requirements, and is established on an item by item basis. This means that some items can have absolutely no quality control, while others can have many required QC tests.

Quality Control Tests are required to do QC testing. The Quality Control Test describes the base name of the test as well as any applicable testing methods and the Unit of Measure that should be used for testing. Quality Control Groups are a list of sequenced Quality Control Tests for the group to perform. QC Groups can be attached to a Part's Item Master to indicate testing required upon PO receipt or on a Bill of Materials to indicate testing required prior to, or following, finishing of material on a production Job. If two items have identical QC Tests and allowable results, they can share the same QC Group. If two items have different QC Tests or different allowable results, they would each have a different QC Group. A system can have as few as one QC Group, or as many QC Groups as there are items, or anything in between. Items may also have multiple QC Groups assigned based on different testing levels. For example, all Raw Materials may be assigned a basic QC Group, with a certain sub set of Raw Materials being assigned an additional QC Group on the Item Master record to ensure these materials undergo additional QC testing requirements.

Quality Control Security Groups are assigned to each Quality Control Test when the test is added to a Quality Control Group. User Groups are then assigned to QC Security Groups using Quality Control Group Security. This grid must be updated whenever a new Quality Control Security Group or User Group is created to ensure the new group has appropriate access. Specific test protocols and security for entering QC data are configured via Quality Control Groups and security for who can enter QC values is configured via Quality Control Security Groups. Additional system security is required to perform functions such as creating or modifying QC Tests and QC Security Groups.

System Navigation

  • Inventory > Maintenance > Quality Control Tests

Edit Quality Control Test form

Opened via the "New" or "Modify" buttons on the Quality Control Tests form.

General tab

Field/Flag

Description

Name

Displays the name of the test.

Test Method

Describes the approved method to be used for conducting the test.

Unit Of Measure

Indicates the Unit used to measure test results. 

Input Mask

Defines the mask, which governs the format, that will be used when entering the results. Note: The value entered in this field will provide the default to "Input Mask" field on the Edit Quality Control Item form when adding this QC Test to a Quality Control Group.

  • Example: If results should always be 4 digits long, the value in this field should be "9999".

Print Mask

Field used for formatting the QC results on forms. When the Print Mask is not used, the Input Mask will be the fallback field used for formatting the QC Results on forms. Input Mask and Print Mask can be used together when users should enter results with 4 decimals, but only display 3 decimals. Note: The value entered in this field will provide the default to "Print Mask" field on the Edit Quality Control Item form when adding this QC Test to a Quality Control Group. 

  • Example: If results should always be displayed with 3 decimals, the value in this field should be “9.999”.

Combine Results

Option to have the system compare the values for the selected criteria in this field on lots being relived to production jobs and transfer those values to the lot produced on the job. Options are None, Weighted Average, Average, Minimum, and Maximum.

  • The QC Tests and QC Groups on the lots being relived must match those of the lot being produced.
  • Business Case: Designed for blended lot scenarios where a lot produced on a job uses/relives multiple lots of the same material that is produced on the job and previously entered QC values can be transferred to the finished lot. The feature works for lots that are set to go into a "Pending QC" status during job finishing.

Active

If checked, this record is active. Only active records may be used in the system.

User Fields tab

User Fields provide companies with a useful tool to add additional information or selection options via the use of list boxes to master data records and orders throughout the Deacom system. Users can add QC Test User Fields to the Inventory Quality Control Tests grid and can also add QC Test User Fields to the QC INFO and QC PARENT INFO block types on COA reports, and on other Part Forms, including PO Labels. The information entered in User Fields is also available for printing on many of the print outs and labels throughout the system. When using the QCINFO and QC PARENT INFO blocks for PO labels, the default values from the Item Master QC group/tests will be printed on the label.

User Fields must first be created before they will be visible on this tab.

Reason Codes

Reason Codes (or Adjustment Reasons) are available for selection on all inventory adjustment and move forms throughout Deacom and also on many of the inventory reports in Inventory Reporting. Reason Codes are also available to the move form in the WMS application. The Reason Codes list can contain an infinite number of entries. Users with access to the Inventory Maintenance menu will have access to create and modify Reason Codes.

System Navigation

  • Inventory > Maintenance > Reason Codes

Edit Inventory Adjustment Reason form

Opened via the "New" or "Modify" buttons on the Adjustment Reasons form.

Field/Flag

Description

Name

Name of adjustment reason, which must be unique.

Inventory Adjustments

Search field used to define an adjustment account for the selected reason.

  • If an account is entered in this field, the system will use this account instead of the selected item's adjustment account when selecting this reason.
  • This account applies when adjusting, not moving, inventory in the system.

Active

If checked, this record is active. Only active records may be used in the system.

Default

If checked, the selected reason is the default when Adjusting Inventory. Users may override the default if necessary.

  • The default flag does not make the selected reason the default when Moving Inventory.

Routings

A Routing in the Deacom system is a series of predefined processing steps, listed in order of sequence, necessary to complete a Part. Each Routing step indicates the Work Center, the Operation that will be performed, and the processing rate for the item in units per hour. Each Routing step has a cost per unit based on the standard operation Labor rate, the Work Center’s hourly cost, and the processing rate. The sum of all the Routing step costs is the total Labor Cost per piece, which is stored in the "Current Labor" field of the Item Master Costs tab. Routings are attached to individual BOM Revisions, which allows for different manufacturing processes for different BOMs.

In addition to the Routings section in Inventory Maintenance, Routings can be created and maintained on the Routings tab in the Bills Of Material or the Item Master areas of the system. The security setting "Item master -- edit routing" controls access to this transaction in all locations. For information on how to configure Routings, refer to the Managing Routings page.

Additional notes regarding Routings include:

  • If modifying a Routing via the "Routings" button on the Job, any changes are made for the Job only and do not impact the Routing group. These changes will be a variance from the standard cost.
  • If an item is a Feature part and modified by the Configurator after the Job is created, Routings are not automatically updated, but can be manually updated if needed.
  • Jobs must be saved before users can modify their Routings.
  • Operations for Jobs due on a certain day that are not scheduled are shown at midnight on the Planned On Hand Calendar view.
    • Example: A Job is created with Routings that are not scheduled, but the Job is due 5/29. On the Planned On Hand Calendar, these Routings will show at midnight on 5/29 for both "Date Based On" of Start and End.
  • When automatic scheduling of routings occur, the system will sort the routings by line number then by routing sequence. In addition, the system will check to see if the next line in the routing uses the previous line in its BOM. If it does, the system will pull in the route time so it does not conflict.

System Navigation

  • Inventory > Maintenance > Routings

Edit Routing form

Opened via the "New" or "Modify" buttons on the Routings form, the Edit Routing form lists all Operations that are assigned to the selected Routing along with several details, such as the associated Work Center, Units, and Hours (specified via the Edit Routing Sequence form) and the following:

  • Machine Cost - Calculated as Work Center Hourly Rate (ce_rate) * Routing Hours (r2_hours).
    • If r2_batch is true and ro_size <> 0, then use ro_size; Otherwise return 0 for the whole calculation.
    • If r2_batch is false and r2_pieces <> 0, then use r2_pieces; Otherwise return 0 for the whole calculation.
  • Labor Cost - Calculated as Operation Cost ($/hr) * Sequence Hours (hr) / Sequence Units (unit).
  • Piece Cost - Cost associated with manufacturing one Unit of the selected item.

Note: Documents attached to the Routing can be printed when using Document Groups by selecting the "Routing" option in the "Print Attached" field on the Document Group master record.

Button/Flag

Description

Add

Opens the Edit Routing Sequence form, which is used add a Sequence to the Routing.

Modify

Opens the Edit Routing Sequence form, which is used to modify the details of the selected Sequence.

Delete

Deletes the selected Sequence from the Routing.

Sort

Allows the user to sort the order of the Sequences for this Routing.

Same As

Allows the user to copy an existing Routing as a starting point, which can then be modified and saved as a new Routing.

Copy Seq

Allows the user to copy the currently selected Routing Sequence.

  • The new Sequence will initially be added to the bottom of the list, but may be sorted as desired.
  • The Edit Routing Sequence form will automatically be opened to modify or confirm the information for the newly created Sequence.

Copy Routing User Fields

If checked, when using the Same As feature the user fields on the routing sequence get copied over; if not checked values will not copy.

General tab

Field/Flag

Description

Name

Displays the name of the Routing, which must be unique.

Batch Size

Indicates the typical number of units produced using this Routing.

Facility

Indicates the Facility for which this Routing is used.

Active

If checked, this record is active. Only active records may be used in the system.

Recalc Batch Std. Labor and Burden by Planned Quantity

If checked, and "Inventory Costing" in System > Options > Inventory tab is set to "Standard Cost" or "FIFO Cost", labor and burden postings are re-calculated based on the Job's planned quantity (lj_planquant) as opposed to the batch size entered on the routing.

  • Allows a Routing to be setup with no Batch size, then when selected on a Job, scale to the Job quantity and appropriately relieve the Operation costs evenly, regardless of the amount of finishes being performed.
  • The formula with this flag checked should be the sum of the costs for each Sequence, calculated as follows:
    • For Sequences that are not flagged as "Batch": Operation rate + Work Center rate * Sequence Workers * Sequence Hours / Sequence Units * amount of Part that was planned.
    • For Sequences that are flagged as "Batch": Operation rate + Work Center rate * Sequence Hours * Sequence Workers.
  • Jobs that do not have Routings will have labor costs equal to the Item Master accounting labor cost times the amount produced.

Schedule Continuously

If checked, indicates this sequence should be scheduled together with other sequences on the same routing and without any gaps. A gap might be another routing sequence, blackout, or open space. This field applies when scheduling routing sequences manually or automatically (earliest, latest, etc.).

  • The "Allow Sequences To Shift" field in Production > Options must be unchecked in order to make this field selectable.
  • Once this field is checked, the "Lead Time" field on the Edit Routing Sequence form will be grayed out, reset to "0", and unavailable for entry since this feature will not work with lead times on sequences.
  • The scheduling of continuous routings will very depending on the setting in the "Lead Time Based On" field.
    • When scheduling the sequence after a sequence with a lead time based on start, both sequences must start at the same time.
    • When scheduling the sequence after a sequence with a lead time based on end, the end time of the first sequence must match the start time of the second sequence.
  • Earliest Available, Latest Available, and Optimize logic: When scheduling jobs automatically, if a place on the schedule can't be found for all sequences while maintaining the continuous logic the jobs should will not be scheduled.
  • See the Scheduling Continuous Routings help section for additional information.
  • This field was added in version 17.02.010.0000.
  • Note that shifting may cause many sequences to move.

MRP tab

 

Field/Flag

Description

Use MRP Settings

If checked, the system will adhere to the values on this record when this Routing is selected on Jobs when running MRP.

Job Minimum

Used in conjunction with the "Split MRP Jobs By Job Quantity" flag on the Item Master Properties tab to define the default minimum batch size, in Stock Units, for produced materials.

  • If the "Split MRP Jobs By Job Quantity" flag is not checked, this value will not be enforced.
  • If a quantity is entered below the value defined in this field, a prompt will appear asking the user if they wish to continue.
  • Users with the security setting "Jobs -- allow quantities less than job minimum" will be permitted to enter non-incremental quantities on Jobs.

Job Maximum

Used in conjunction with the "Split MRP Jobs By Job Quantity" flag on the Item Master Properties tab to define the default maximum batch size, in Stock Units, for produced materials.

  • If the "Split MRP Jobs By Job Quantity" flag is not checked, this value will still be enforced.
  • If a quantity is entered above the value defined in this field, a prompt will appear asking the user if they wish to continue.
  • Users with the security setting "Jobs -- allow quantities greater than job maximum" will be permitted to enter non-incremental quantities on Jobs.
  • If the "Use MRP Settings" flag is unchecked, the Job Maximum field in Item Master will be used instead in a Work Center Capacity Report.

Incremental Job Qty

Used in conjunction with the "Job Minimum" and "Job Maximum" fields to define the increment at which Jobs for this Part/Routing combination must be created and therefore constrain Job quantities to a multiplier.

  • Users with the security setting "Jobs -- allow non-incremental quantities" will be permitted to enter non-incremental quantities on Jobs.
  • Example: If the suggestion for a manufactured item is truly "247", the "Job Minimum" is set to "300", and this field is set to "50", the suggestion will be "300".

User Fields tab

Deacom allows the creation of user-defined fields that, once created, are available on various master data records such as items, Vendors, and Ship-to Companies. These fields allow companies to enter and store information outside of the fields provided in the system. User fields may be added via Tools > Maintenance > User Fields. 

Edit Routing Sequence form

Opened via the "Add" or "Modify" buttons on the Edit Routing form. When editing a Routing for a specific Job via the "Routing" button on the Job, several additional fields are available:

  • Due Date and Due Time - Define the date and time the materials are due for the Job.
  • Pieces - Defines how many outputs or pieces are needed to complete the Operation.
  • Planned Hours - Indicates how long the task should take to complete, which allows the system to compare the actual hours/dollars to the planned hours/dollars.
    • The Job Reporting "Job Cost Summary" report uses this field to calculate the standard labor.
    • When modifying an existing Job Routing, this field is read only.

General tab

Field/Flag

Description

Operation

Search field used to select the Operation, which supplies the standard hourly labor cost, for which this Routing is used.

  • Each Operation has a separate GL account for posting labor and overtime expenses.

Restrict To Work Center

Pick list used to determine if the selected Operation should be restricted when a user attempts to manually modify the Work Center on a Job Routing Step from the Job header. Options are:

  • None - User is allowed to select from a list of all Work Centers.
  • Work Center - User is only allowed to select from the list of Work Centers directly attached to the Routing Step.
  • Work Center Type - User is allowed to select from a list of all Work Centers that have the same Work Center Type as any of the Work Centers attached to the Routing Step.

Units

Defines how many outputs or pieces will be completed by the Operation in the time specified in the Hours field. If the "Batch" flag is set, this field will be grayed out.

Hours

Defines the amount of time required to complete the Operation. If the "Batch" flag is set, this operation will take the same amount of time for all jobs. Batch size or job size will not be considered.

Crew Size

Defines the number of Workers required to complete all Units within the Hours entered on the Sequence.

  • This field may contain up to two decimals.
  • This field is not required by the Deacom system but may be required based on individual customer requirements and SOPs.

Lead Time Based On

Pick list used to dictate if the "Lead Time" will be based on the Start or End of the Job.

Lead Time

Used in conjunction with the "Lead Time Based On" selection and the Master Production Calendar to indicate the lead time, in hours, for this Sequence.

  • Example: Assume there is Job with a "Planned Start" date of Jan 12 and one of the Job's Routing steps has a three day Lead Time (represented in hours). The system will indicate a "Due" date of Jan 15 on the Routing Calendar Detail form for this Job Routing Sequence.
  • Decimals and negative numbers are not permitted in this field.
  • If the "Schedule Continuously" check box on the General tab of the Routing form is checked, this field will be grayed out and unavailable for entry and the entry in this field, if set, will be reset to "0".

Unavailable For Next Sequence

If checked, the Work Center using this routing sequence on the Master Production Calendar will be unavailable for scheduling based on where and when Operations on subsequent sequences occur. 

Notes

Memo field used to store processing notes specific to this Sequence.

Batch

Used to indicate if the Operation being performed takes a set amount of time regardless of the "Batch Size" defined on the Routing.

  • When calculating labor cost
    • If checked, the system will divide the "Hours" specified on the General tab by the "Batch Size" on the Routing.
    • If checked, the "Units" field on the Edit Routing and Edit Routing Sequence forms will be grayed out.
    • If not checked, the system will use the normal calculation of "Hours" divided by "Units".
      • Example: Cleaning a machine after use takes 1.5 hours regardless of the "Batch Size".

Finishing

Used to indicate if this Routing Sequence is a finishing step.

  • When finishing Job lines, labor and burden costs for the sequences flagged as "Finishing" are totaled separately and stored in the new "Finishing Labor" and "Finishing Burden" columns available to the Job Reporting "Job Cost Detail" report.
  • Useful for customers looking for more labor tracking detail in the "Job Cost Detail" report.

Schedule Around Blackouts

Checked by default. When checked, routing sequences will be scheduled on the Master Production Calendar over non-maintenance blackouts. Routing sequences will be scheduled to start before a blackout and then continue thereafter.

  • The "Process Jobs Over Non-Maintenance Blackouts" field in Production > Options must be checked in order to use this field.
  • If this field is unchecked, the system will either move the sequences forward or backward on the calendar depending on the scheduling method and continuous logic below:
    • If any sequence on the routing is unable to be scheduled without crossing a blackout/unavailability period the system will not schedule the entire job.
    • When manually re-scheduling an already scheduled sequence or placing a sequence on the calendar from the list of sequences in the bottom grid of the calendar, and the user places the sequence in a spot that would result in crossing a blackout/unavailability period, the following prompt: "This sequence can't be scheduled across scheduled across black outs." will be display and the system will put the sequence back where it was, and not move any others.
    • When manually re-scheduling a sequence to a valid Work Center and the user answer yes to move earlier/later/unscheduled sequences the system will check the setting in this field to ensure schedule around blackout setting is considered.
  • Added in version 17.02.010.0000.

Include in Optimization

Used to indicate if the sequence is susceptible to the Optimize function in the Master Production Calendar. Defaults to True. When set to False, the selected sequence will remain in its initially scheduled time even if the Optimize function is used. 

Zero Cost

When checked, all machine, labor, piece, etc. costs will be set to zero and not appear in any labor cost roll ups.

Operation Complete

Only available when editing/adding Routing Sequences in Job Reporting. Used for reporting purposes to indicate that this operation, for the selected job, is complete.

  • Once checked, can only be unchecked by navigating directly to the specific routing sequence on the job and un-checking it.
  • In order for this flag to activate for selection, the user will need to select a Work Center and Operation that match those on the job's routing.
  • When the "Operation Complete" checkbox on the Edit Log On/Off Job form is checked for a Job Routing Sequence that matches the Job/Work Center/Operation then this filed will be checked.

Work Center tab

The Work Center tab lists all Work Centers and pertinent information to which the selected Sequence covers. At least one Work Center must be added to a Routing to save it.

Edit Routing form

Field/Flag

Description

Work Center

Search field used to select the Work Center, typically a specific machine within a given Shop Area, to which this Routing and the values below apply.

  • Only Work Centers with Shop Areas that belong to the Facility selected on the Edit Routing form will appear in the list as available to select.
  • Min Job Line Qty and Max Job Line Qty are available to set on the Work Center.

Units

Defines how many outputs or pieces are needed to complete the Operation for the selected Work Center. If the "Batch" flag is set, this field will be grayed out.

Hours

Defines the amount of time required to complete all Units for the selected Work Center.

Crew Size

Defines the number of Workers required to complete all Units within the Hours entered on the Sequence for the selected Work Center.

  • This field may contain up to two decimals.
  • This field is not required by the Deacom system but may be required based on individual customer requirements and SOPs.

Lead Time Based On

Pick list used to dictate if the "Lead Time" will be based on the Start or End of the Job.

Lead Time

Used in conjunction with the "Lead Time Based On" selection and the Master Production Calendar to indicate the lead time, in hours, for this Sequence for the selected Work Center.

  • Users can schedule overlapping Routing Sequences within the same Work Center. See Scheduling overlapping Routing Sequences for more information.
  • Users can schedule concurrent Routing Sequences for different Work Centers. See Scheduling concurrent Routing Sequences for more information.
  • Decimals and negative numbers are not permitted in this field.

Notes

Memo field used to store processing notes specific to this Sequence for the selected Work Center.

Inherited

If checked, will inherit the units, hours and crew size from the values on the General tab.

Default

If checked, this is the default Routing when this Operation is performed on the selected Work Center.

User Fields tab

Deacom allows the creation of user-defined fields that, once created, are available on various master data records such as items, Vendors, and Ship-to Companies. These fields allow companies to enter and store information outside of the fields provided in the system. User fields may be added via Tools > Maintenance > User Fields. 

Schedule Sequencer 1-2

Scheduling Sequencers are used by the optimization wizard located on the toolbar of the Master Production Calendar and provide planners with an option to prioritize how items on active production Jobs should be scheduled. Two sequence levels are available and each item may be assigned to one Schedule Sequence 1 and one Schedule Sequence 2. The optimization wizard will search for items assigned to level 1 sequences first, then assign Jobs containing these items to the appropriate Work Center or Shop Area. Next, the optimization wizard will search for items assigned to level 2 sequences (after items with level 1 sequences have been assigned) and then assign Jobs containing these items to the appropriate Work Center or Shop Area.

Once scheduling sequences have been created they may be selected via the search boxes in the "Schedule Sequencer 1" and "Schedule Sequencer 2" fields located on the Item Master General 1 tab. In situations where scheduling sequences need to be assigned to multiple Item Master records, the spreadsheet option in the "Change From" field via Inventory > Price Updates may be used.

Note: The schedule sequencer 1 option can also be used with the scheduled changeover feature. 

System Navigation

  • Inventory > Maintenance > Schedule Sequencer 1-2

Edit Schedule Sequencer 1-2 form

Opened via the "New" or "Modify" button on the Schedule Sequencer 1-2 form.

Button/Field/Flag

Description

Name

Defines the name of the schedule sequencer.

Active

If checked, this record is active. Only active records may be used in the system.

Sort

Used to change the sort order of the Schedule Sequences in the list, which appears in the search box in the "Schedule Sequencer 1-2" fields on the Item Master General 1 tab.

Sub-Categories

Inventory Sub-Categories allow companies to further group items that share similar characteristics and are useful for inventory reporting purposes. In addition, Sub-Categories are one of the criteria for Deal Pricing, Promotions and Commissions. Categories may contain multiple Sub-Categories but only one Sub-Category may be assigned to an item. Users with access to the Inventory Maintenance menu will have access to add and modify Sub-Categories.

Sub-Category names only have to be unique within their own Category and not throughout all Categories.

System Navigation

  • Inventory > Maintenance > Sub-Categories

Edit Sub-Category form

Opened via the "New" or "Modify" buttons on the Sub-Categories form.

General tab

Field/Flag

Description

Features

If clicked, displays the Features form, which is used to manage sales features applicable to this Sub-Category. Features, used in connection with the Deacom Product and Sales Configurator, are a group of similar options that may be chosen or configured based on different sales choices.

Category

Search field used to select the Category to which the Sub-Category will be assigned.

  • If one Category contains multiple Sub-Categories, a new record will be needed in the Sub-Categories table for each Category/Sub-Category combination.

Sub-Category

Displays the name of Sub-Category, which must be unique within one Category.

  • The Sub-Category name can be re-used for each Category. Example:

  Category      Sub-Category

  Candies       Chocolate-Covered

  Pretzels       Chocolate-Covered

Sales Quota

Stores the planned annual sales in dollars for the selected Sub-Category.

  • This field is available for use in the Sales Ranking reports located in Sales > Order Reporting.

Active

If checked, this record is active. Only active records may be used in the system.

Restricted Selling

If checked, indicates this is a restricted Sub-Category. Restricted selling may be used in a few different ways.

Deacom allows the creation of user-defined fields that, once created are available in various master data records, such as Items, Vendors, Ship-To-Comapnies and many others. These fields allow companies to enter and store information outside of the fields provided in the system. User fields can also be used in connection with User Calculations to and are available for printing on the majority of Part Forms and Report Layouts throughout the system.

Units tab

The Units tab allows companies to define the number of minutes required per unit to receive and ship items in the selected sub-category and is used in conjunction with the Dock calendar to schedule orders. Note: Unit Minutes may also be defined on individual Units of Measure,  Item Masters, and Categories, allowing companies to define a hierarchy for the minutes that will be required for receiving and shipping.

Button/Field/Flag

Description

Unit Of Measure

Select an appropriate Unit of Measure from the drop down list.

Receiving Minutes

Numeric field used to define the minutes required to receive the Unit of Measure when receiving items in the specified Unit Of Measure that are assigned to this Sub-Category.

Shipping Minutes

Numeric field used to define the minutes required to ship the Unit of Measure when shipping items in the specified Unit Of Measure that are assigned to this Category.

Features form

Opened via the "Features" button on the Edit Sub-Category form. Displays a list of the Features that have been added to the Category.

Button

Description

Add

If clicked, opens the Edit Feature form and allows the user to select a Feature.

  • The Endpoints or sub-Features within the Feature will be available to all items within the Sub-Category, unless overridden at the Item Master level.
  • Those overrides can remove Endpoints or sub-Features, but not add them, so all available Endpoints and Features should be defined at the Feature level and subtracted from the Feature tree at the appropriate Category, Sub-Category, or Item Master level.

Overrides

If clicked, opens the Feature Overrides form, which displays a feature tree of this Sub-Category and all available options and prices, with the capability of overriding pricing and availability. 

  • Overrides established at the Category level are in effect at the Sub-Category and Item Master levels, unless overridden at those levels.
  • Once an override is modified and saved, the new value from the Sub-Category level will be inherited to the Item Master level.

Inclusions

If clicked, opens the Feature Inclusions form, which displays a list of the inclusions and exclusions that have been added to the current Feature.

View Tree

If clicked, displays a feature tree of the selected Feature and all attached options and prices, which can be printed or exported to Excel.

Units of Measure

In Deacom, unit conversion factors are stored centrally in the Unit of Measure table. The advantage of this setup is that the conversion factor can be noted once instead of multiple times in the Item Master setup. Additionally, since the conversion factor between units is established, the purchasing and sales functionality in Deacom is no longer limited to operating with the Item Master’s Unit of Measure. The setup of the unit of measure conversion factors affects Items Masters, Purchase Orders, Sales Orders, BOM maintenance, and production Jobs.

In addition, the amount of time it takes in minutes to prepare a specific Unit of Measure for shipment, or the amount of time it takes to unload a specific Unit of Measure, can be specified on the Unit of Measure record. This feature supports the Dock scheduling capability within Deacom. 

Base Units

Each type of unit (each, cube, length, volume, or weight) must have a single base unit of measure established in the form, which will be used for all conversion factors. This base unit is selected by checking the "Base Unit" flag on the Edit Unit of Measure form. All the base units should have the "Factor" set to 1. Additional units of measure created with conversion factors are known as derived units.

For organizations who work primarily in imperial units, the base unit for volume and weight will be gallons and pounds, respectively. For example, if the base unit for weight is pounds, then the conversion factor for the kilogram unit will be 2.2046 because there are 2.2046 pounds per kilogram.

For the purpose of purchasing and sales packaging where package items are not being used in Deacom, boxes, bags, drums, pails, and other types of packaging can be defined as containing a certain number of base units. For example, a Unit of Measure can be setup called “Box - 20 lb”. Every possible packaging type that requires conversion must be present in the Unit of Measure table.

Example setups

Below are examples of how the Unit of Measure table can be setup in Deacom for both Imperial Standard and Metric.

Imperial Standard

Metric

Name

Type

Factor

Base Unit

Name

Type

Factor

Base Unit

Each

Each

1

Yes

Each

Each

1

Yes

Box - 12

Each

12

No

Box - 12

Each

12

No

Case - 24

Each

24

No

Case - 24

Each

24

No

Feet

Length

1

Yes

Meter

Length

1

Yes

Yard

Length

3

No

Centimeter

Length

.01

No

Inch

Length

.08333

No

Kilometer

Length

1000

No

Gallon

Volume

1

Yes

Liter

Volume

1

Yes

Quart

Volume

.25

No

Centiliter

Volume

.01

No

Pint

Volume

.125

No

Kiloliter

Volume

1000

No

Pound

Weight

1

Yes

Gram

Weight

1

Yes

Gram

Weight

.00220462

No

Centigram

Weight

.01

No

Kilogram

Weight

2.20462

No

Kilogram

Weight

1000

No

MBF

Cube

1

Yes

Cubic Meter

Cube

1

Yes

BF

Cube

.001

No

Cubic Centimeter

Cube

.000001

No

Cubic Feet

Cube

.0120004

No

Cubic Kilometer

Cube

1,000,000,000

No

Lumber

Lumber is normally stocked by the stick, with pricing by the MBF. MBF is defined as the base unit for the Cube UOM. As the base unit, the factor is 1.00. The pricing factor is on the "Unit Cube" field of the Item Master Calcs tab. If a Pricing factor is set to show that each stick equals 0.012 MBF and 1,000 sticks are purchased at the cost of $420 per MBF, then the following two equations can be used to determine the correct extension:

  1. Order Amount in Stock Unit x Pricing Factor from Unit Cube = Order amount in Stock Pricking Unit (In this case, 1,000 pieces x 0.012 MBF per piece = 12 MBF.)
  2. Order Amount in Stock Pricing Unit x Purchase cost = Extension (In this case, 12 MBF x $420/MBF = $5040.)

This transaction would put 1,000 sticks into inventory, at the cost of $5,040 for the load. Divided by 1,000 sticks, the total shows that the individual Lot cost is $5.04 per stick. The GL transaction of the receipt would put the $5,040 into inventory, crediting AP Suspense for the same amount. If done in standard cost mode, and the purchase price are the same as the standard cost, so there would be no purchase price variance.

Weight to volume and volume to weight conversions

While the relationship between one weight unit and another, like pounds and kilograms, or one volume unit and another, like gallons and liters, is constant and can be stored in the Unit of Measure table, the relationship between weight and volume is different from one item to the next, and must still be stored on the Item Masters Calcs tab. The Calcs tab contains the conversion factors, for a specific item, between weight, volume, cube, and length. The five fields on the tab used for weight to volume and volume to weight conversions are as follows: Unit Weight, Unit Volume, Unit Cube, Unit Length, and Tare Weight.

System Navigation

  • Inventory > Maintenance > Units of Measure

Edit Unit of Measure form

Opened via the "New" or "Modify" buttons on the Units of Measure form.

General tab

Field/Flag

Description

Name

The name of the Unit of Measure.

Type

Pick list used to define the measurement type. Options are:

  • Cube
  • Each
  • Length
  • Volume
  • Weight

Factor

Defines the conversion factor used by the UOM flagged as "Base Unit" for the same "Type".

  • Example: A "Bag - 50lb" UOM with a "Type" of "Weight" would have a "Factor" of "50", representing 50 pounds per one bag.

Shipment Mins

Defines the time in minutes that it takes to load a "Sales Unit" defined on the Sales Order line.

  • Used in connection with the Dock Calendar.
  • Example: A tanker truck takes 30 minutes to load at the dock.
  • This field provides the default for the "Dock Minutes" (or_dockmins) field on the Edit Sales Order Line General tab.
  • Shipment Minutes may also be defined on Item Masters, Categories, and Sub-Categories, allowing companies to define a hierarchy for the minutes that will be required for shipping.
  • When specifying Dock Minutes on a Sales Order line, the minutes are based on the "Sales Unit", not the "Stock Unit".

Receipt Mins

Defines the time in minutes that it takes to unload a "Purchase Unit" defined on the Purchase Order line.

  • Used in connection with the Dock Calendar.
  • Example: A tanker truck takes 30 minutes to unload while backed into the dock.
  • This field provides the default for the "Dock Minutes" (pu_dockmins) field on the Edit Purchase Order Line General tab.
  • Receipt Minutes may also be defined on Item Masters, Categories, and Sub-Categories, allowing companies to define a hierarchy for the minutes that will be required for receiving.
  • When specifying Dock Minutes on a Purchase Order line, the minutes are based on the "Purchase Unit", not the "Stock Unit".

FedEx Unit

Pick list required if using the FedEx API used to select the unit that will be used to measure shipments.

  • For Each type packages, select "Each".
  • The unit selected in this field will also be visible in the "IATA Unit" pick list on the Item Master Calcs tab.

FedEx Factor

Defines the conversion factor.

  • Required if using the FedEx API.
  • For Each type packages, use a value of 1.
  • Example: If using a UOM of "Box - 10lb", enter a value of 10 in this field.

EDI Code

Defines the standard EDI code used for the Unit of Measure. The most commonly used codes are indicated below. Please note this is not an all inclusive list.

  • Bag = BG
  • Barrel = BR
  • Bottle = BO
  • Box = BX
  • Bucket = BC
  • Can = CN
  • Case = CA
  • Dozen = DZ
  • Drum = DR
  • Each = EA
  • Fluid Ounce = FO
  • Gallon = GA
  • Gram = GR
  • Keg = KE
  • Kilogram = KG
  • Liter = LT
  • Milliliter = ML
  • Ounce Av = OZ
  • Package = PK
  • Pail = PA
  • Pair = PR
  • Pallet = PLT
  • Pound = LB
  • Quart = QT
  • Unit = UN
  • Note: The stockunitedi, pricunitedi and saleunitedi variables are available to sales order header triggers and sales printouts to represent the EDI codes defined in this field.

Base Unit

If checked, the selected UOM is the base unit for the designated measurement "Type".

  • Example: If "Type" is set to "Weight", the base unit would most likely be one pound.

Active

If checked, this record is active. Only active records may be used in the system.

Default

If checked, the selected UOM is used as the default when new Parts are created.

Restrict Sales Picking to Container Units

If checked for a sales unit, the user will only be allowed to pick Lots with the matching container unit when reserving and shipping in both the main app and when reserving in WMS.

Deacom allows the creation of user-defined fields that, once created are available in various master data records, such as Items, Vendors, Ship-To-Comapnies and many others. These fields allow companies to enter and store information outside of the fields provided in the system. User fields can also be used in connection with User Calculations to and are available for printing on the majority of Part Forms and Report Layouts throughout the system.

Vehicles

System Navigation

  • Inventory > Maintenance > Vehicles

Vehicles form

Edit Vehicles form

Button/Flag

Description

Name

Enter name of vehicle

Facility

 

Active

Check to make the vehicle active

Zones

Zones represent a series of inventory locations. When setting up a warehouse in Deacom, customers can do so by Zone to improve the efficiency of picking for both Jobs and Sales Orders. Zones are comprised of specific Locations within the warehouse and often have operators assigned directly to the Zone for picking purposes.

Considering warehouse hierarchy, Zones are optional. While Facilities, Location Types, and Locations are required within Deacom, customers have the option of whether or not to take advantage of Zones through the configuration process. One helpful use of Zones is in situations where large orders require more than one person to pick for the order. For example, if the warehouse is set up by aisles A-Z, one person can pick in aisles A-D (Zone A to D) and another person can pick in aisles E-J (Zone E to J), etc.

As mentioned above, there are also restrictions available by Zone. The "Zone" field on the Facility Item form, available on the "Facilities" tab of the Item Master record, restricts what inventory can be received to only Locations within the destination Location's Zone. This is useful for situations where companies need to restrict items to certain areas of the warehouse. For example, certain materials can only be stored in the cooler. This "Zone" field on the Facility item will direct users to the cooler and not allow users to move this product into a non-cooler Location. Only available in web versions of Deacom. Also, when a user is restricted to a Zone, they can only issue, pick, and ship (without assigning lots) from within their Zone. Specifically, issuing, reserving, shipping, moving, staging, and receiving (on negative Purchase Orders) inventory should limit the lot chooser to only seeing lots from the specified Zone. Scanning a lot should confirm that the lot is in that Zone. This essentially breaks down to inventory that is in Locations that are in the User's Zones.

System Navigation

  • Inventory > Maintenance > Zones

Edit Zone form

Opened via the "New" or "Modify" buttons on the Zones form.

Field/Flag

Description

Name

Name of the Zone, which must be unique. 

Facility

Pick list used to select the Facility that the Zone will belong to. Multiple Zones may be assigned to one Facility.

Part

 

Active

If checked, this record is active. Only active records may be used in the system.

Note: After inactivating Zones, scanner users must log out then back in to Deacom to refresh the Zones list.

Default

If checked, this will be the default Zone on forms throughout the system that contain a "Zone" field. Users may override the default if necessary.

Prevent Inventory Transactions

If checked, prevents inventory transactions (issuing, reserving, moving) other than physical inventory postings from occurring for this record. This flag should be selected during physical inventories to ensure that no transactions occur between the time the inventory snapshot is taken and the time when the physical inventory worksheet is posted. When this flag is checked, if a user attempts to perform inventory transactions in the system for the Zone, a system prompt will be displayed to prevent the transaction from occurring.

Note: This flag also exists on Item Master records, Facilities, Locations, and Location Types. Also, when the "Automatically Prevent Included Item Transctions" field on the Physical Inventory Forms form is checked, this prevents users from performing inventory transactions on all items, or facility-specific items, if a Facility is indicated on the form when performing a physical inventory or cycle count. The field allows companies to more quickly prevent inventory transactions then using the alternative option of checking the "Prevent Inventory Transaction" flag on the item master record, either individually, or via the Price Updates Excel feature.

Edit Location form

Opened via the "Add" or "Modify" buttons on the Edit Zone form.

Field

Description

Location

Pick list used to select the Locations that will belong in this Zone. A blank value for location is not allowed, but the use of the name “None” is valid.